mysql数据库T-SQL创建表

// 朱茂强 qq：896228072（望大牛多多指点）
create database zmq,
use zmq //建成数据库完成后，需要用use打开一次，再创建表不然建的表在系统数据库里
create table Department 
(
DepID smallint not null primary key,//单个主键直接跟primary key
DepName varchar(40) not null ,
Describ varchar(400) null,
UpperID smallint null,
)
create table employees
(
EmpID char(8) not null primary key,
EmpName varchar(10) not null ,
Sex char(2) null check(Sex='男'or Sex='女'),//check约束
MaritalCondition bit null check(MaritalCondition='1'or MaritalCondition='0'),
DepID smallint null,
foreign key(DepID) references Department (DepID),//创建外键
)
create table hokdpost
(
EmpID char(8) not null,
DepID smallint not null, 
primary key(EmpID,DepID),
foreign key(DepID) references  Department(DepID),//DepID必须在Department表中是主键
foreign key(EmpID) references  employees(EmpID),//EmpID必须在 employees表中是主键
//创建多个外键可以分步创建
）
create table checkin
(
EmpID char(8) not null ,
checkinmonth date not null ,
primary key(EmpID,checkinmonth),//设置多个主键，需要先描述完，然后一起创建
)