SHOW CREATE TABLE t_book;
ALTER TABLE t_book DEFAULT CHARACTER SET utf8;
ALTER TABLE t_book CHANGE name
name
VARCHAR(200) CHARACTER SET utf8;
ALTER TABLE t_book CHANGE author author VARCHAR(200) CHARACTER SET utf8;
注释:t_book是表,name ,author是属性
SHOW CREATE TABLE t_book;
ALTER TABLE t_book DEFAULT CHARACTER SET utf8;
ALTER TABLE t_book CHANGE name
name
VARCHAR(200) CHARACTER SET utf8;
ALTER TABLE t_book CHANGE author author VARCHAR(200) CHARACTER SET utf8;
注释:t_book是表,name ,author是属性