创建数据库
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 );
查询数据
SELECT column_name,column_name
FROM table_name;
UPDATE 更新
UPDATE table_name SET field1=new-value1, field2=new-value2;
DELETE 语句
DELETE FROM table_name;