建立資料庫
CREATE DATABASE database_name;
建立資料表
CREATE TABLE table_name (column1_name data_type constraints,column2_name data_type constraints,....
);
插入資料
INSERT INTO table_name (column1,column2,...) VALUES (value1,value2,...);
查詢資料
SELECT column1_name, column2_name, columnN_name FROM table_name;
刪除資料
DELETE FROM table_name WHERE condition;
修改資料
UPDATE table_name SET column1_name = value1, column2_name = value2,...WHERE condition;
清空表
TRUNCATE TABLE table_name;
刪除表
DROP TABLE table1_name, table2_name, ...;
where
SELECT column_list FROM table_name WHERE condition;