Tables Part 4 – Advanced

/* Change Table Name */
ALTER TABLE new1 RENAME osama;

/* Change Many Fields Name And Type */
ALTER TABLE students MODIFY username char(50), CHANGE id userid int(11);

/* Change Many Fields Name And Type */
ALTER TABLE students MODIFY username varchar(255), CHANGE userid id tinyint(1);

/* Change Character Set UTF-8 */
ALTER TABLE students CONVERT TO CHARACTER SET utf8;

/* Change Character Set Latin 1 */
ALTER TABLE students CONVERT TO CHARACTER SET latin1;