MySQL Forums
Forum List  »  Newbie

Error Creating a Table
Posted by: kbshook
Date: July 20, 2005 06:32PM

The MySQL is giving me problems at the start by not letting me create a database because of the following error: 1064 (42000)

My MySQL connection id is 5 to server version: 4.1.12a-nt


mysql> CREATE TABLE ClientData (Client ID NUMBER(5) PRIMARY KEY,
-> Last Name VARCHAR2(20), First Name VARCHAR2(20), Address VARCHAR2(20),
-> City VARCHAR2(20), State VARCHAR2(2), Zip NUMBER(5),
-> Phone VARCHAR2(15);
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 'ID NU
MBER(5) PRIMARY KEY,
Last Name VARCHAR2(20), First Name VARCHAR2(20), Addre' at line 1

I need help!

Thanks, kbshook

Options: ReplyQuote


Subject
Written By
Posted
Error Creating a Table
July 20, 2005 06:32PM
July 21, 2005 06:29PM
July 21, 2005 06:36PM
July 22, 2005 08:05PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.