4
【笔记】Mysql创建数据库和数据表时指定字符集
source link: https://loli.fj.cn/2023/03/27/Mysql%E5%88%9B%E5%BB%BA%E6%95%B0%E6%8D%AE%E5%BA%93%E5%92%8C%E6%95%B0%E6%8D%AE%E8%A1%A8%E6%97%B6%E6%8C%87%E5%AE%9A%E5%AD%97%E7%AC%A6%E9%9B%86/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
【笔记】Mysql创建数据库和数据表时指定字符集
2023-03-27
Mysql创建数据库和数据表时指定字符集
创建数据库时指定字符集
<database>：数据库名
CREATE DATABASE <database> CHARACTER SET utf8 COLLATE utf8_general_ci;
创建数据表时指定字符集
<table>：数据表名
CREATE TABLE <table>(
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK