Computing.Net > Forums > Database > MySQL Syntax Error 1064

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

MySQL Syntax Error 1064

Reply to Message Icon

Name: jsebastian1680
Date: August 16, 2006 at 16:46:20 Pacific
OS: XP
CPU/Ram: 2.8Ghz/1GB
Product: Dell
Comment:

Running MySQL Version: 5.0.22

Trying to create a table using the MySQL Query Browser and also within the Command Line Client (If I try to create a table called product within the test database) :

CREATE TABLE `test`.`Product` (
)
ENGINE = InnoDB;

*
I am getting a 1064 Error while executing query.
Any ideas on what is wrong with the syntax ?



Sponsored Link
Ads by Google

Response Number 1
Name: jsebastian1680
Date: August 17, 2006 at 04:39:03 Pacific
Reply:

I forgot to add a column when creating a table. Everything is ok now.


0
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Database Forum Home


Sponsored links

Ads by Google


Results for: MySQL Syntax Error 1064

error 1054 in mysql www.computing.net/answers/dbase/error-1054-in-mysql/188.html

using administrator to reset psswrd www.computing.net/answers/dbase/using-administrator-to-reset-psswrd/432.html

What's wrong with this MS Access Qu www.computing.net/answers/dbase/whats-wrong-with-this-ms-access-qu/363.html