It is because of the syntax for that command. In your case, old_column_name and new_column name would be identical. You would want to basically redefine it exactly as before (you're not changing from int to auto_increment, for example), except that you would add the auto_increment characteristic. You basically give the column you want to change and completely redefine it.
Happy hacking. Chris Ryan A wrote: >Am a bit confused, 2 guys already gave me the advise you are giving me but >you also say >"CHANGE COLUMN old_column_name new_column_name" >why to change the column name? dont I only have to change it from being an >"int" to an "Auto_Increment"? > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php