Next and Preview Row

know the values of ID00025 is in Row 11. Thank you so much for your help. Mark Lo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Next and Preview Row

know the values of ID00025 is in Row 11. Thank you so much for your help. Mark Lo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

double quotes and single quotes

Hi, I have a problem with double quotes and single quotes in mysql command, if I let my user input the form data and it contains double quotes, the values cut off at the double quote. How to override the problem ?? Thank you Eric Chan

simpify chinese and traditional chinese

Hi, Is it possible for mysql to store simpify and tranditional chinese. Thanks Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)

Can't connect throught over server.

Hi, I am not able to connect mysql server through other machine in a network. I have already assign the user using the command of Grant all on *.* to user@ipaddress identified by password. Then, try to connect using mysql -u user@ipaddress -h firstserver -ppassword.But, I got

Can't connect error 111

Hi, I am not able to connect mysql server through other machine in a network. I have already assign the user using the command of Grant all on *.* to user@ipaddress identified by password. Then, try to connect using mysql -u user@ipaddress -h firstserver -ppassword.But, I got

bind to specific address

Hi, How to bind mysql to specific address if I am using my.cnf file. etc. [mysqld] --bind-address=xxx.xxx.xxx.xxx Is the above syntax correct ?? Thanks Mark - Before posting, please check:

Problem with Update to 3.23.38

HI, I got the following problem with apache_1.3.20 + modssl-2.8.4-1.3.20 + openssl-0.9.6a + php-4.0.5 + mysql-3.23.38. After I upgrade the system, I can only connect to mysql server via the consle window. But, I am not able to use the php-mysql command to connect to the server via the

listen to specific address

Hi, I would like to know how to tell mysql to listen to specific foreign address. I know I can use --bind-address to tell mysql to listen to specific local address. But I need mysql to listen to specific foreign address. HOW TO DO IT. Thank you Mark

set variable for max_connections

Hi, I would like to set a higher values in max_connections for mysql. I have tried to use the following command mysqld --set-variables max_connections=900 -u root -ppassword. Then, it shows that I have successfully changed the variable of max_connections. But, when I check it with the

Re: set variable for max_connections

what I did wrong. Thank You Mark - Original Message - From: John Barton [EMAIL PROTECTED] To: Mark Lo (3) [EMAIL PROTECTED] Cc: ComMysql@Lists. Mysql. [EMAIL PROTECTED] Sent: Friday, May 11, 2001 12:53 AM Subject: Re: set variable for max_connections Try putting a line like the following

suggestion needed about du command run on PHP

Hi, I would like to run a du command to find out how many bytes of each databases is consuming under PHP+ Apache. But, the problem is I am not able to count the bytes of the databases in MySQL, because the user and group is set to MySQL. On the other hand, My Web server is running on user

show table status command in MySQL

Hi, For show table status command in MySQL, which field is indicate the table size? Or, Which command is to find out the database size. Thanks in advance mark - Before posting, please check:

how to measure databases

Hi, I would like to know how to measure how many MB of one particular databases is taken in PHP command. I know I can always use the command of du ... . But this command is not work under apache because the user and group are nobody, while the user and group for mysql is mysql, also the

mysqldump --opt

Hi, As I know, mysqldump --opt command will lock all the tables at once. I got confused from the above statement. What I have been confused is that if I have three databases. And I am trying to backup all three databases, using mysqldump --opt database1 /xxx/datatbase1.sql ...etc... The

Re: Mysqld crashes with my DELETE query.

Hi, May be, you run out of memories. Try to use --large-table command to startup mysqld. Hope this help.. - Original Message - From: "BAUMEISTER Alexandre" [EMAIL PROTECTED] To: "Heikki Tuuri" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, April 03, 2001 6:49 PM Subject:

Storing Chinese in MySQL database

Hi, I would like to know how to store chinese in MySQL Databases. What type of column should I use ?? Thank You Mark Lo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

3.23.35 failed to upgrade

Hi, I am trying to upgrade my MySQL server to 3.23.35 from 3.23.33. The following command is used. I got the following error messages. Any Ideas !! rpm -Fvh MySQL-client-3.23.35-1.i386.rpm MySQL-devel-3.23.35-1.i386.rpm MySQL-client-3.23.35-1.i386.rpm MySQL-client