!"##$%&"'"(
)*+"*' ,"*' "-./012$3+3"-4!50$.$
4!
",6 !"7-"8##94#4#!35
完整的SQL语句
create database S_C
use S_C
create table Student(
StuID char(8) not null primary key ,
StuName varchar(10)not null,
Tel varchar(13),
Sage smallint,
Ssex char(2)default '男' check (Ssex in ('男','女')),
Semail varchar(20),
Sintday datetime,
GradeID char(6) not null,
Snation varchar(20),
Sadd varchar(40),
)
create table Grade(
GradeID char(6) not null primary key,
GName varchar(20) not null,
GNum int not null,
Gassist varchar(10),
Gdept varchar(20),
Gacademy varchar(20)
)
select *from Grade
create table Teacher(
TID char(4) not null primary key,
TName varchar(10) not null,
Temail varchar(20),
Tsex char(2),
Tnation varchar(20),
Tadd varchar(20),
Ttel varchar(13)
)
create table Course(
CID char(6) not null primary key,
CName varchar(20)not null,
Cnum varchar(2),
Ccapa varchar(3),
Cdate datetime,
Croom char(5),
6
:;: <<, !"::::53-
$58*;3=%:::>:,3?5$="">"'"+"
"'./010+@(3 5+7(+0A0A(@#B(+0AC=D0EEF"'"+CD
G./0/-=:A1.:36@($
资源评论
老帽爬新坡
- 粉丝: 92
- 资源: 2万+
