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]