创建数据库
CREATE DATABASE 数据库名;
删除数据库
drop database <数据库名>;
创建表
CREATE TABLE table_name (column_name column_type);
删除表
DROP TABLE table_name ;
数据的增删改查
增加
INSERT INTO table_name ( field1, field2,...fieldN )
VALUES
( value1, value2,...valueN );
删除
DELETE FROM table_name [WHERE Clause]
修改
UPDATE table_name SET field1=new-value1, field2=new-value2
[WHERE Clause]
查询
SELECT column_name,column_name
FROM table_name
[WHERE Clause]
[LIMIT N][ OFFSET M]