Re: MySQL Create Table Problem
| From: | rm | Date: | Fri, 02 Mar 2001 19:55:45 +0000 |
| Subject: | Re: MySQL Create Table Problem | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-42389@lists.php.net to get a copy of this message | ||
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/