-- 建立表

CREATE TABLE 表名(

)ENGINE=存储引擎(MYISAM INNODB) AUTO_INCREMENT=100 DEFAULT CHARSET=utf8;

CREATE TABLE t1(t INT);

CREATE TABLE t2(t INT);

CREATE TABLE t3(t INT);

SHOW CREATE TABLE t;`t1`

CREATE DATABASE aa DEFAULT CHARACTER SET utf8;

USE aa;

CREATE TABLE t1(

tid INT UNSIGNED NOT NULL AUTO_INCREMENT,

tname VARCHAR(30) NOT NULL,

PRIMARY KEY(tid)

)ENGINE=MYISAM AUTO_INCREMENT=201401 DEFAULT CHARSET=utf8;

-- 删除表

DROP TABLE t1;

DROP TABLE IF EXISTS t1;

-- 删除多个表

DROP TABLE t1,t2,t3;

-- 修改表名 修改为student 下面两个语句等价

RENAME TABLE t1 TO student;

ALTER TABLE student RENAME t1;

-- 显示表的信息

DESC t1;

-- 修改列名

ALTER TABLE t1 CHANGE tid sno INT;

ALTER TABLE t1 CHANGE tname sname VARCHAR(30) NOT NULL;

-- 增加一列

ALTER TABLE t1 ADD sscore TINYINT;

ALTER TABLE t1 ADD asddress VARCHAR(50) AFTER sname;

-- 删除列

ALTER TABLE t1 DROP COLUMN asddress;

ALTER TABLE t1 DROP COLUMN sscore;