MySQL相关的建表语句

create table class(
 cid int auto_increment primary key,
 caption VARCHAR(16)
)engine=innodb default charset=utf8;


create table student(
 sid int auto_increment primary key,
 sname char(12),
 gender char(1),
 class_id int,
CONSTRAINT fk_s17_1 FOREIGN KEY (class_id ) REFERENCES class(cid)
)engine=innodb default charset=utf8;


create table teacher(
 tid int auto_increment primary key,
 tname VARCHAR(16)
)engine=innodb default charset=utf8;


create table course(
 cid int auto_increment primary key,
 cname char(12),
 teacher_id int,
CONSTRAINT fk_s17_2 FOREIGN KEY (teacher_id ) REFERENCES teacher(tid)
)engine=innodb default charset=utf8;



create table score(
 sid int auto_increment primary key,
 student_id int,
 course_id int,
number int,
CONSTRAINT fk_s17_3 FOREIGN KEY (student_id ) REFERENCES student(sid),
CONSTRAINT fk_s17_4 FOREIGN KEY (course_id ) REFERENCES course(cid)
)engine=innodb default charset=utf8;

我自己的建表语句：

主机表建表语句:depsys

create table host_table(
 host_id int auto_increment primary key,
 username char(12),
 password char(15),
 ip char(30),
 port int
)engine=innodb default charset=utf8;


create table depart_table(
 depart_id int auto_increment primary key,
 depart_name char(30)
)engine=innodb default charset=utf8;


create table user_table(
 user_id int auto_increment primary key,
 username char(12),
 password char(15),
 mailbox char(30),
 depart_id int,
constraint c1 foreign key (depart_id) references depart_table(depart_id)
)engine=innodb default charset=utf8;



create table user_host_table(
 user_id int ,
 host_id int ,
constraint c2 primary key (user_id,host_id),
constraint c3 foreign key (user_id) references user_table(user_id),
constraint c4 foreign key (host_id) references host_table(host_id)
)engine=innodb default charset=utf8;

最近的建表语句:

建表语句:

create table dbs_info(
 id bigint,
 type_no varchar(20),
 handle_time varchar(30),
 yn varchar(10),
 reason varchar(30),
 tele int default 0,
constraint c1 primary key (id)
)engine=innodb default charset=utf8;

INSERT INTO tbl_name (col1,col2) VALUES(col2*2,15); 

insert into dbs_info(id,type_no,handle_time,yn,reason) values(6844,'普通上线','2017年10月27日15:02:04','1','无drop语句');