首页 > 代码库 > mysql 常用指令

mysql 常用指令

 

修改表的字符集

 

88down voteaccepted

If you want to change the table default character set and all character columns to a new character set, use a statement like this:

ALTER TABLE tbl_name CONVERT TO CHARACTER SET charset_name;

So query will be:

ALTER TABLE etape_prospection CONVERT TO CHARACTER SET utf8;

mysql 常用指令