easy mysql question
Posted: Thu Jan 11, 2007 4:01 pm
i have a database table, one of the columns is set to CHAR(20)... how do i change it to CHAR(30) using the mysql command line?
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
ALTER TABLE `table_name` CHANGE `field_name` `field_name` INT( 30 ) NOT NULL AUTO_INCREMENT
Code: Select all
ALTER TABLE `table_name` CHANGE `field_name` `field_name` VARCHAR( 30 )