newbie ALTER syntax help

[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 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.

 

[sleipnir214]

I don't think you can abbreviate "Primary Key" as "PK". And that is the point at which MySQL barfs on the query.


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[cLFlaVA]

interesting terminology...

*cLFlaVA
----------------------------
Breaking the habit...