Re: Error on MySQL-5.0

Moon's Moon's Father escreveu: You may execute mysql_fix_privileges_table script to upgrade all of your mysqld. I did it, but the problem persists... :-/ +-+---+--++

Error on MySQL-5.0

Hi, I installed MySQL-5.0.67_1. When I execute CHECK TABLE information_schema.COLUMNS FOR UPGRADE I get the message: ++---+--++ | Table | Op|

Re: Error on MySQL-5.0

You may execute mysql_fix_privileges_table script to upgrade all of your mysqld. On Thu, Nov 20, 2008 at 7:54 PM, Ronan Lucio [EMAIL PROTECTED] wrote: Hi, I installed MySQL-5.0.67_1. When I execute CHECK TABLE information_schema.COLUMNS FOR UPGRADE I get the message:

Creating table syntax error with mysql 5.0!

I'm new with MySQL server 5.0 ,I tried to create a table MemberDetails from the mysql command shell, I got an error 1064 (42000): *You have an error in your SQL syntax*; Here is my code: mysql CREATE TABLE memberDetails - *(* -memberId INT NOT NULL AUTO_INCREMENT, -

Re: Creating table syntax error with mysql 5.0!

mysql CREATE TABLE memberDetails - *(* -memberId INT NOT NULL AUTO_INCREMENT, -PRIMARY KEY(memberId), -first_name varchar(100), -last_name varchar(100), -Email varchar(60), -phoneNum varchar(25) - *);* Works without the