MySQL's way to rename a column is: ALTER TABLE table CHANGE columnold columnnew constraints;
How would I remain the constrains? I do not want to specify lets say tinyint unsigned not null auto_icnrement. Is there a way to 'grab' those details and put it in the clause? I have a script that occasionally modifies the column name, however, the script can not know the details about the column, just the name. So is there a way in MySQL to select (or something) the details and use the same for the new column?
Thanks for help!