1.编写sql脚本,例如:
create data mysqlStudy;
use mysqlStudy;
create table person(
id int not null auto_increment,
name varchar(40) not null,
age int,
city varchar(20),
salary int,
primary key(id)
)engine=innodb charset=gb2312;
将该脚本存成 person.sql
2.执行sql脚本,可以有2种方法: