在mysql中创建表，数据库

//修改数据库的字符集
alter database blog character set utf8;
//创建数据库
create database mydb

CREATE TABLE publisher (
id int(12) NOT NULL auto_increment,
pname varchar(50) default NULL,

PRIMARY KEY (id)
)engine=InnoDB default charset=utf8;
//Mysql 插入记录 instert语句详解
insert into publisher values(‘1’,‘科技出版社’);
//添加外键约束方式一

CREATE TABLE book (
id int(12) NOT NULL ,
bname varchar(200) default NULL,
pid int(12) NOT NULL auto_increment,
CONSTRAINT fk_pid FOREIGN KEY (pid) REFERENCES Publisher(id),

PRIMARY KEY (pid)
)engine=InnoDB default charset=utf8;

[CONSTRAINT <外键名>] FOREIGN KEY 字段名 [，字段名2，…]
REFERENCES <主表名> 主键列1 [，主键列2，…]

CREATE TABLE book (
id int(12) NOT NULL auto_increment,
bname varchar(200) default NULL ,
pid varchar(50) ,
PRIMARY KEY (id)
)engine=InnoDB default charset=utf8;

CREATE TABLE publisher (
id varchar(50) ,
pname varchar(50) default NULL ,
PRIMARY KEY (id)
)engine=InnoDB default charset=utf8;

CREATE TABLE student (
sno varchar(6) ,
sname varchar(100) NOT NULL ,
ssex varchar(100) ,
sage int(11) ,
sclass varchar(10) ,
PRIMARY KEY (sno)
)engine=InnoDB default charset=utf8;

CREATE TABLE archives (
id int(6) auto_increment ,
idcard varchar(18) NOT NULL ,
address varchar(200) ,
student_id varchar(6) NOT NULL ,
unique(idcard),
unique(student_id),
PRIMARY KEY (id)
)engine=InnoDB default charset=utf8;

create table user like dj03.user;
show tables;

insert into user select * from dj03.user;