Thursday, July 9, 2015

How would you change a column from VARCHAR(10) to VARCHAR(50)?



ALTER TABLE techpreparation_questions CHANGE techpreparation_content techpreparation_CONTENT VARCHAR(50).
ALTER TABLE `mnu1` CHANGE `mnu1_page` `mnu1_page` VARCHAR( 57 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL

No comments: