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]

Reply via email to