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
Subject
Written By
Posted
Error Creating a Table
July 20, 2005 06:32PM
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.