mysql相关命令
一、mysql中修改表的默认编码和表中字段的编码
- 修改表的编码格式的
ALTER TABLE `table` DEFAULT CHARACTER SET utf8;
- 修改所有字段的编码格式
alter table `tablename` convert to character set utf8;
ALTER TABLE `table` DEFAULT CHARACTER SET utf8;
alter table `tablename` convert to character set utf8;