RE: [PHP-WIN] [N-PHP-R] Help with MySQL

>> >ALTER table balh chage column foo foo int(5)unsigned >> >> Does the key word CHANGE COLUMN really exists with in MySQL?? That would be >> amazing to be ale to change the domain of an attribute just like that. >> >Yep >Syntax (Nicole, this is the correct syntax by the way... :-) : > >ALTER TABLE table_name CHANGE orig_col_name new_col_name >new_col_attributes > >In fact, the column must be defined again from scratch, no attributes are >carried over from the previous definition if you ALTER it. Which suggest that the RDBMS internally first makes a DROP COLUMN, and then perform an ADD COLUMN, well, if the column attributes is not preserved, then I would like to suggest to use "ALTER TABLE <table name> DROP CONSTRAINT <constraint>" to change a constraint - this will keeps the attributes. Second reason for not using CHANGE COLUMN would then be to keep compatibility between different platforms.