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 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 name of a column, but I have to also "restate" > >the type and sttribute on the column while i do that AFAIK. Can someone > >show me my syntax error? The statement above is exactlymy try from the > >mysql comd. line Thanks. > > The problem is shown by the error message: PK isn't valid. > Do you mean PRIMARY KEY?
Yes. Fixed it, Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]