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. Have fun Symeon Charalabides (cosmopolitan trainee) ------------------------------------------ http://www.webmate.gr