// 创建数据库

CREATE DATABASE db_name;

// 删除数据库

DROP DATABASE db_name;

// 显示数据库

SHOW DATABASES;

// 选择数据库

USE db_name;

// 显示表

SHOW TABLES;

// 创建表

CREATE TABLE customer (

  id bigint(20) unsigned NOT NULL AUTO_INCREMENT,

  name varchar(32) NOT NULL DEFAULT '',

  PRIMARY KEY (id)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

// 查看表结构

DESC customer;

SHOW CREATE TABLE customer \G;

SHOW TABLE STATUS LIKE 'customer' \G;

// 删除表

DROP TABLE customer;

// 修改表中某一字段数据类型

ALTER TABLE customer MODIFY COLUMN name varchar(16) NOT NULL DEFAULT '' AFTER id;

// 修改表中某一字段名称

ALTER TABLE customer CHANGE COLUMN name nickname varchar(16) NOT NULL DEFAULT '' AFTER id;

// 添加新字段

ALTER TABLE customer ADD COLUMN last_name varchar(16) NOT NULL DEFAULT '' AFTER id;

// 删除某一字段

ALTER TABLE customer DROP COLUMN nickname;

// 插入数据

INSERT INTO customer(id, first_name, last_name, nickname) VALUES(10000,'Wayne', 'Bruce', 'Batman');

// 部分插入数据

INSERT INTO customer(first_name, last_name) VALUES('Logan', 'Howlett');

// 省略字段名称

INSERT INTO customer VALUES(10002, 'Banner', 'Bruce', 'Hulk');

// 省略字段名称(auto_increament)

INSERT INTO customer VALUES(NULL, 'Stark', 'Tony', 'Iron Man');

// 更新记录

UPDATE customer SET nickname = 'Wolverine' WHERE id = 10001;

// 删除记录

DELETE FROM customer WHERE nickname LIKE '%Iron%';