try renaming the column and excecuting the query again ;)
gesf Active member Jun 27, 2005 #2 Example: Code: ALTER TABLE table_name CHANGE 'field_name' 'new_field_name' SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT
Example: Code: ALTER TABLE table_name CHANGE 'field_name' 'new_field_name' SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT
Alexej Kubarev New member Jun 27, 2005 #3 for more information about SQL statements: http://dev.mysql.com
