MySQL Database Forum

Hi all and Merry Christmas! I wanted to ask how would I deal with the following problem: Say I have a table : customerid name 1 nick 2 george 3 harry

visit http://www.dbnest.com/dbexperts.php?currentpage=24 to find a list of MySQL leading professinals, if you consider your self a mysql Expert email your info to admin@dbnest.com with your profile, picture, links of your blog, website etc. Saghir Taj www.dbnest.com: The Nest of DB Professionals.

visit http://www.dbnest.com/dbexperts.php?currentpage=24 to find a list of MySQL leading professinals, if you consider your self a mysql Expert email your info to admin@dbnest.com with your profile, picture, links of your blog, website etc. Saghir Taj www.dbnest.com: The Nest of DB Professionals.

visit http://www.dbnest.com/dbexperts.php?currentpage=24 to find a list of MySQL leading professinals, if you consider your self a mysql Expert email your info to admin@dbnest.com with your profile, picture, links of your blog, website etc. Saghir Taj www.dbnest.com: The Nest of DB Professionals.

visit http://www.dbnest.com/dbexperts.php?currentpage=24 to find a list of MySQL leading professinals, if you consider your self a mysql Expert email your info to admin@dbnest.com with your profile, picture, links of your blog, website etc. Saghir Taj www.dbnest.com: The Nest of DB Professionals.

visit http://www.dbnest.com/dbexperts.php?currentpage=24 to find a list of MySQL leading professinals, if you consider your self a mysql Expert email your info to admin@dbnest.com with your profile, picture, links of your blog, website etc. Saghir Taj www.dbnest.com: The Nest of DB Professionals.

visit http://www.dbnest.com/dbexperts.php?currentpage=24 to find a list of MySQL leading professinals, if you consider your self a mysql Expert email your info to admin@dbnest.com with your profile, picture, links of your blog, website etc. Saghir Taj www.dbnest.com: The Nest of DB Professionals.

Updated to the latest version of DBD-mysql using perl -MCPAN -e "install DBD-mysql" and now the calling mysql function r2() within perl work > $SQL_Text = "select r2() from dual " ; > $sth=$dbh->prepare($SQL_Text); > $sth->execute(); > while ( ($tt) = $sth->fetchrow_array( ) ) { print $tt; } for reference here is the mysql...

I've a PHP script that is supposed to write results to a file using INTO OUTFILE, but it's not. The mysql_error says: Could not write file: Can't create/write to file '/var/www/html/accounts/samplesdownload/1136572640.txt' (Errcode: 2) The permissions on that folder has "a+w -R" chmoded to it, and in fact, other scripts can write to it,...

I do not understand what is wrong with my query: mysql> update prices,prices_tmp set prices.new_ecampus=prices_tmp.new where prices.isbn = prices_tmp.isbn; ERROR 1064: You have an error in your SQL syntax near 'prices_tmp set prices.new_ecampus=prices_tmp.new where prices.isbn = prices_tmp.' at line 1

Updated to the latest version of DBD-mysql using perl -MCPAN -e "install DBD-mysql" and now the calling mysql function r2() within perl work > $SQL_Text = "select r2() from dual " ; > $sth=$dbh->prepare($SQL_Text); > $sth->execute(); > while ( ($tt) = $sth->fetchrow_array( ) ) { print $tt; } for reference here is the mysql...

Hi all, I'm newbie in MySql and have been working for some time with MS Sql Server; so i'm familiar with stored procedures. However, i'm trying to create a simple stored procedure in MySql Query Browser (assuming there is a table called 'Categories') such as: Create Procedure sp_ShowAllCategories () BEGIN

all, I've just tried to re-start a replication process and the slave's tables came up marked as crashed. I'm doing a repair on one of them but there are a lot of databases/tables so I can't check them all (or is there a table entry somewhere that flags crashed tables?) Here is the sequence I used: On Slave (FreeBSD-6.0): Stop slave...

i'm building a website for a band and each section of the site, i want to have google style searches. mainly, for the news and tour section. i'm using mysql 4.0.26 and php 4.0 for all web content. below is the query i created for the tour search (this example looks for 3 search items). php builds this dynamically but for each search term,...

Hi, I'd like to replace every instance of £ with £ in a text field in my database. The field contains text and £ will be one character amongst many. Is this possible? Enter

I have replication all set to go between an ubuntu Master and a FreeBSD Slave. However, no matter what I try I can't get telnetd to run on the master and the slave is not connecting (I am assuming it's using telnet). Can someone point me to a dumbed-down recipe on altering my existing my.cnf files to use SSL for the replication connection to...

Hi, I installed Mysql Administrator with file mysql-administrator-1.0.22a-1.rh9.src.rpm from the mysql-site on my RedHat 9.0 computer I did: rpm -Uvh mysql-administrator-1.0.22a-1.rh9.src.rpm After one second, i could see: ##################### 100% and that's it.

I have a search form from which I hope to be able to select a record by field JobNumber and display it with an output form titled test.php <html> <head> <title>Job Database Search</title> </head> <body style='font-family: Geneva, Arial, Helvetica, sans-serif;'> Enter Job Number: <form action="test.php" method="post">

Hi, I am using MySQL 5.0 beta and Active Python 2.4. I have the correct version of MySQLdb installed. The problem is that I can't connect to MySQL through the Active Python interactive window. Here is a sample error: >>> c=MySQLdb.Connect(host='localhost',user='root',passwd='',db='shop',port=3306) Traceback (most recent call last):

Hi all, I have a number of tables that I want 'timestamped' with both a modified and created 'timestamp' field. Ideally both fields should 'work if ignored' in insert and updates, thus the following is fine for a modified timestamp field tsm: tsm timestamp default current_timestamp on upate current_timestamp

Hey, I have MySql 5.0.18 and Connector/net 1.0.7 installed and am using c# to connect to a remote database. If I execute the EXE in the debug folder (or choose start without debugging from the debug menu) then it all seems to work fine and my applicaiton can connect to the database. But if I debug the application through Visual Studio then...

Hi everybody and Happy New Year! I have been dealing with this problem of my biology class lesson since yesterday, I believe it's some silly mistake I am making. I have these tables: protein_id protein.name 1 PROTEIN_1 2 PROTEIN_2 3 PROTEIN_3

Hi Folk I wanted to do a simple update like this in version 3.23.58 of MySql: Update CLI, TEMP set CLI.ORN = TEMP.C WHERE CLI.ID = TEMP.CLI_ID; Turns out you can not. What is going on here and what are my alternatives?

I am trying to write a front end for a MySql database and can't get it to work. I seem to be missing something fundemental. The code below works fine and returns an HTML page with the desired output. However, it I remove the "#" from the two lines which are commented out, I get a blank page as an output. Can anyone see anything I'm doing...

if i am having one database .i want to see whether there is any changes in the database.is there any option