• 
• Item
• 3 March 2011
• Jaymon

Mysql changing a column type #mysql #learned

ALTER TABLE tbl_name CHANGE field_name field_name field_type;

so, to change the username field on the table user to TEXT: ALTER TABLE user CHANGE username username TEXT;

http://www.roseindia.net/sql/mysql-alter/mysql-alter-column-datatype.shtml