Sql分类
- 数据库定义: CREATE, ALTER, DROP, DELETE
- 数据库操作: SELECT, DELETE, UPDATE, INSERT
常用
- 创建数据库: CREATE DATABASE dbname
- 删除数据库: DROP DATABASE dbname
- 创建表: CREATE TABLE tablename(….),CREATE TABLE tablename AS SELECT col1,col2… from TABLE tablename
- 删除表: DROP TABLE tablename
- 增加列: Alter table tabname add column col type
- 添加主键: Alter table tabname add primary key(col)
- 创建索引: CREATE -