导入数据的语句
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','!&','我爱中国');
将上述语句存为 testimport.sql
a.命令行 mysql
在cmd中执行
mysql -uroot -p123 -Dsakila