创建数据库 CREATE DATAbase XXXX CHARACTER SET utf8 COLLATE utf8_general_ci;
[为什么utf8_general_ci,网上说建立库最好用]
创建表
CREATE TABLE XXXX(
id int PRIMARY KEY,
username varchar(240)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

创建数据库 CREATE DATAbase XXXX CHARACTER SET utf8 COLLATE utf8_general_ci;
[为什么utf8_general_ci,网上说建立库最好用]
创建表
CREATE TABLE XXXX(
id int PRIMARY KEY,
username varchar(240)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;