一、 创建数据库
create database test; use test;
二、创建表 create table Students (Sno char(7) primary key, Sname varchar(10), Ssex char(2) default '男', Sbirthday date, Sdept varchar(12), Memo varchar(30) ); create table Courses (Cno varchar(4) primary key, Cname varchar(20), PreCno varchar(4), Credit tinyint ); create table SC (Sno char(7), Cno varchar(4), Grade tinyint, foreign key(sno) references Students(Sno), foreign key(cno) references Courses(Cno), primary key(Sno,Cno) );
三、向表中插入数据
insert into students values('0602001','钟耀华','男','1987-05-01','计算机','优秀毕业生'); insert into students values('0602002','吴佳硕','女','1987-03-24','计算机','爱好:音乐'); insert into students values('
精彩内容
发表评论