Mysql 库、表、字段字符集

mac2022-06-30 83

show character set;show create database aloe;show create table book_category;show full columns from book_category;

ALTER DATABASE `aloe` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `book_category` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `book_category` CHANGE `name` `name` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL

转载于:https://www.cnblogs.com/yako/p/4542686.html

相关资源：JAVA上百实例源码以及开源项目

最新回复(0)

Mysql 库、表、字段 字符集