# ######## 数据库相关 # 创建库 CREATE DATABASE 库名 IF NOT EXISTS;
# 修改库名 RENAME DATABASE books TO 新库名;
# 删除库 DROP DATABASE IF EXISTS books;
# ######### 表相关 # 创建表 CREATE TABLE IF NOT EXISTS customers ( cust_id int NOT NULL AUTO_INCREMENT, # 自动增加 cust_name char(50) NOT NULL DEFAULT GEL, # 设默认值 cust_address char(50) NULL, cust_city char(50) NULL, cust_state char(5) NULL, cust_email char(255) NULL, PRIMARY KEY (cust_id) # 指定主键 ) ENGINE=InnoDB;
CREATE TABLE IF NOT EXISTS student ( id int NOT NULL AUTO_INCREMENT, name char(50) NOT NULL, address char(50) NULL, city char(50) NULL, email char(255) NULL, PRIMARY KEY (id) ) ENGINE=InnoDB;