mysql表操作

查看数据库表结构

SHOW COLUMNS FROM tabl_name

插入记录

INSERT [INTO] tbl_name [(col_name,...)] values (val1,...)

添加单列

ALTER TABLE tb_name ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name]

添加多列

ALTER TABLE tb_name ADD [COLUMN] (col_name column_definition ,...)

删除列

ALTEER TABLE tb_name DROP [COLUMN] (col_name),DROP [COLUMN] (col_name),

添加主键约束

ALTER TABLE tbl_name ADD
[CONSTRAINT[symbol]] PRIMARY KEY (index_col_name,...)

添加唯一约束

ALTER TABLE tbl_name ADD
[CONSTRAINT[symbol]] UNIQUE (index_col_name,...)

添加外键约束

ALTER TABLE tbl_name ADD
[CONSTRAINT[symbol]] FOREIGN KEY (index_col_name,...) reference_definition