Re: newbie ALTER syntax help

2004-09-23 Thread leegold
On Thu, 23 Sep 2004 15:51:56 -0500, "Paul DuBois" <[EMAIL PROTECTED]> said: > At 12:12 -0400 9/23/04, leegold wrote: > > alter table keywords change key_id page_id int(10) unsigned NOT NULL PK > > auto_increment; > >ERROR 1064 (42000): You have an error in your SQL syntax; check the > >manual th

Re: newbie ALTER syntax help

2004-09-23 Thread Paul DuBois
At 12:12 -0400 9/23/04, leegold wrote: alter table keywords change key_id page_id int(10) unsigned NOT NULL PK auto_increment; 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 'PK auto_increme

newbie ALTER syntax help

2004-09-23 Thread leegold
alter table keywords change key_id page_id int(10) unsigned NOT NULL PK auto_increment; 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 'PK auto_increment' at line 1 I'm trying to change the