1 创建表
CREATE TABLE table_name
(field_name data_type [NOT NULL]|[NULL] [PRIMARY KEY]......
.
.
.
)
若仿照另一个表来新建该表用:create table …… as ……
create table table_name1 as select coumn1,column2…… from table_name2
2 修改表
ALTER TABLE table_name
ADD|DROP|ALTER column_name/constraint_name......
3 删除表
DROP TABLE table_name
4 插入数据
1) INSERT TABLE table_name (field_name,field_name......) values (........)
2) INSERT ... SELECT ...要先创建INSERT的表
若全部复制另一个表内容用:insert into table_name1 select * from table_name2
5 更新数据
UPDATE table_name SET field_name = value where field_name = value
6 删除数据
DELETE FROM table_name where field_name = value
7 查看表结构
desc table_name