创建库
create database BASENAME;
例:create database USERS;
进入库
use basename;
例:
use users;
创建表
create table tablename(
a1 type [not null],
a2 type [not null]
)
例:
create table USERS(
user_qq varchar(20) not null,
user_name varchar(20) not null,
user_sex char(2) not null,
user_phone varchar(11) not null)
主键约束
例:
create table USERS(
user_qq varchar(20) not null primary key,
user_name varchar(50) not null,
user_sex char(2) not null,
user_phone varchar(11) not null)
外键约束
例:
create table SCORE(
user_name varchar(50) not null REFERENCES USERS(user_name),
score int not null)
检查约束
例:
create table USERS(
user_qq varchar(20) not null check(user_qq>0),
user_name varchar(50) not null,
user_sex char(2) not null)
默认约束
例:
create table USERS(
user_qq varchar(20) not null,
user_name varchar(50) not null,
user_sex char(2) not null default ‘男’,
user_phone int not null)
自增约束
例:
create table GAMES(
gno int not null AUTO_INCREMENT,
name varchar(50) not null)
#删除库
drop database BASENAME;