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?
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
