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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]