> >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 -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
