MySQL导入N种实现方式
导入数据的语句
set character_set_client = utf8;
use sakila;
drop table stt;
create table stt
( id int not null,
str1 char(10) not null,
str2 varchar(60) not null,
str3 varchar(70) not null,
primary key(id)
) engine = InnoDB default charset = utf8mb4 ROW_FORMAT=COMPACT ;
insert into stt
values(2,'abcd22','！&','我爱中国');
