I am a newbie to MySQL. I have created a personnel database and have successfully added several tables. I am in the process of creating more tables, but I cannot get past this error:
#1064 - 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 'CREATE TABLE pers_paf_addr ( pers_addr_paf_no INT(9) NOT NULL, pers_ad' at line 3
Here is the code I am using:
CREATE TABLE pers_paf_addr (
pers_addr_paf_no INT(9) NOT NULL,
I have compared this to code that worked and cannot seem to determine why it is failing.
table create error
Post a Reply
|Oldest Newest Rating|
SQL & Databases
Everything SQL and Databases related in here!
|Bucky Roberts Administrator|