RE: Error creating table in MySQL 5.0

2004-05-10 Thread Victor Pendleton
Have you verified the syntax from the MySQL command line? -Original Message- From: Marvin Cummings To: [EMAIL PROTECTED] Sent: 5/9/04 7:26 PM Subject: Error creating table in MySQL 5.0 Wondering if anyone can give me some help with this error I'm getting when trying to create this

Re: Error creating table in MySQL 5.0

2004-05-09 Thread Peter Brawley
If a column is auto_increment it can't be DEFAULT 0. PB - Original Message - From: Marvin Cummings To: [EMAIL PROTECTED] Sent: Sunday, May 09, 2004 7:26 PM Subject: Error creating table in MySQL 5.0 Wondering if anyone can give me some help with this error I'

Error creating table in MySQL 5.0

2004-05-09 Thread Marvin Cummings
Wondering if anyone can give me some help with this error I'm getting when trying to create this table: ERROR 1064 (42000): You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '$sql = "CREATE TABLE $subdivtab