mysql:sql character set utf8mb4 新建utf8mb4表

create table tweets(weiboid varchar(20) not null ,primary key(weiboid),fromweibo varchar(20),dateandtime datatime,username varchar(100),userid varchar(20).weibocontent varchar(350) character set

ShellDawn

8308人浏览 · 2017-05-04 15:10:37

ShellDawn · 2017-05-04 15:10:37 发布

create table tweets(
weiboid varchar(20) not null ,primary key(weiboid),
fromweibo varchar(20),
dateandtime datatime,
username varchar(100),
userid varchar(20).
weibocontent varchar(350) character set utf8mb4 collate utf8mb4_unicode_ci default null,
transfernum int(10),
commentnum int(10),
likenum int(10),
tools varchar(100) character set utf8mb4 collate utf8mb4_unicode_ci default null
)default charset = utf8mb4;