无标题1.sql

来自「通过JDBC连接数据库」· SQL 代码 · 共 11 行

CREATE table S --创建数据表S
(
sno char(6) default "J0400" not null ,
sname char(8) not null,
birthday datetime default "1980-01-01",
sdepartment varchar(20),
tel char(8) not null,
primary key (sno),
check (sno like "[A-Z][0-9][0-9][0-9][0-9]"),
check (tel like "[0-9][0-9]-[0-9][0-9][0-9][0-9]")
)