Shouldn't the primary key spec come at the end of the
table create command, not in the middle ex...

CREATE TABLE president (
last_name varchar(15) NOT NULL,
first_name varchar(15) NOT NULL,
suffix varchar(5) NOT NULL,
city varchar(20) NOT NULL,
state varchar(2) NOT NULL,
birth date NULL,
death date NULL,
primary key (first_name))

something like the above.



__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to