DDL—數(shù)據(jù)定義語言(Create，Alter祷蝌，Drop，DECLARE)
DML—數(shù)據(jù)操縱語言(Select帆卓，Delete巨朦，Update，Insert)
DCL—數(shù)據(jù)控制語言(GRANT剑令，REVOKE糊啡，COMMIT，ROLLBACK)
庫
CREATE
CREATE DATABASE db_name;
DROP
DROP DATABASE db_name;
SHOW
SHOW DATABASES;
SHOW CREATE DATABASE db_name;
USE
USE db_name;
表
CREATE
CREATE TABLE tb_name(.......);
SHOW
SHOW TABLES;
DESC
DESC db_name;
RENAME
RENAME TABLE tb_name TO new_tb_name;
DROP
DROP TABLE tb_name;
ALTER
修改字段
字段（列）
ALTER MODIFY
ALTER TABLE tb_name MODIFY column ......
ALTER CHANGE
ALTER TABLE tb_name CHANGE column_name new_name
ALTER DROP
ALTER TABLE tb_name DROP column
ALTER ADD
ALTER TABLE tb_name ADD column ......
記錄
SELECT FROM
SELECT * FROM tb_name WHERE,,,;
INSERT INTO
INSERT INTO table_name ( field1, field2,...fieldN )
VALUES
( value1, value2,...valueN );
UPDATE SET
UPDATE table_name SET field1=new-value1, field2=new-value2
WHERE Clause
DELETE FROM
DELETE FROM table_name [WHERE Clause]
GRANT
GRANT 權(quán)限1吁津，權(quán)限2...
ON 對象類型 對象名
TO 用戶1棚蓄，用戶2...
(WITH GRANT OPTION) ;
REVOKE
REVOKE 權(quán)限1,權(quán)限2...
ON 對象類型 對象名
FROM 用戶1,用戶2...;
