介绍“代码”类1,创建数据库
create database if not exists cs2013;
2、创建数据库表格
create table if not exists comp (
id int not null primary key auto_increment
pid varchar (30), not null unique
cname varchar (30), not null
ename varchar (30), not null
grade varchar (30), not null ,,
sex int not null
clothe varchar (15), not null
)default charset =, utf8;
create table if not exists team (
id int not null primary key auto_increment
cname varchar (30), not null
ename varchar (30), not null
coach0 int not null ,,
coach2 int not null
stu0 int not null
stu1 int not null
stu2 int not null
isgirls int not null
email varchar (30), not null
phone varchar (15), not null
foreign key (coach0), references comp (id),,
foreign key (coach2), references comp (id),,
foreign key (stu0), references comp (id),,
foreign key (stu1), references comp (id),,
foreign key (stu2), references comp (id)
)default charset =, utf8;
create table if not exists college (
id int not null primary key auto_increment,
cname varchar (30), not null
ename varchar (30), not null
teamcnt int not null
)default charset =, utf8;
create table if not exists rc (
id int not null primary key auto_increment
college int not null
team int not null
date date not null
foreign key (学院),references college (id),,
foreign key (团队),references team (id)
)default charset =, utf8;
create table if not exists room (
id int not null primary key auto_increment,
name varchar (30), not null
totcnt int not null
regcnt int not null
price double not null
)default charset =, utf8;
create table if not exists hotel (
id int not null primary key auto_increment,
name varchar (30), not null
room0 int not null
room1 int not null
room2 int not null
foreign key (room0), references room (id),,
foreign key (room1), references room (id),,
foreign key (room2), references room (id)
)default charset =, utf8;
create table if not exists rh (
id int not null primary key auto_increment,
college int not null
hotel int not null
date date not null
foreign key (学院),references college (id),,
foreign key (酒店),references hotel (id)
)default charset =, utf8;
这篇文章主要讲解了“数据库SQL语句的使用”,文中的讲解内容简单清晰,易于学习与理解,下面请大家跟着小编的思路慢慢深入,一起来研究和学习”数据库SQL语句的使用”吧!
感谢各位的阅读,以上就是“数据库SQL语句的使用”的内容了,经过本文的学习后,相信大家对数据库SQL语句的使用这一问题有了更深刻的体会,具体使用情况还需要大家实践验证。这里是,小编将为大家推送更多相关知识点的文章,欢迎关注!
