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.


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 (
To unsubscribe, visit:

Reply via email to