目錄blog：https://www.cnblogs.com/Rohn/
SQL語言大致分為
DCL、DDL、DML三種，本文主要介紹MySQL 5.7版本DML陳述句，
- 概述
- 關鍵字
- INSERT陳述句
- 語法格式
- DELETE陳述句
- 語法格式
- 單表洗掉
- 多表洗掉
- UPDATE陳述句
- 語法格式
- 單表更新
- 多表更新
- 語法格式
- SELECT陳述句
- 語法格式
概述
DML(Data Manipulation Language)陳述句：資料操縱陳述句，用于添加、洗掉、更新和查詢資料庫記錄，并檢查資料完整性.
關鍵字
INSERTDELETEUPDATESELETE
INSERT陳述句
參考：INSERT Syntax
INSERT陳述句主要用于向資料表中插入資料，
語法格式
INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE]
[INTO] tbl_name
[PARTITION (partition_name [, partition_name] ...)]
[(col_name [, col_name] ...)]
{VALUES | VALUE} (value_list) [, (value_list)] ...
[ON DUPLICATE KEY UPDATE assignment_list]
INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE]
[INTO] tbl_name
[PARTITION (partition_name [, partition_name] ...)]
SET assignment_list
[ON DUPLICATE KEY UPDATE assignment_list]
INSERT [LOW_PRIORITY | HIGH_PRIORITY] [IGNORE]
[INTO] tbl_name
[PARTITION (partition_name [, partition_name] ...)]
[(col_name [, col_name] ...)]
SELECT ...
[ON DUPLICATE KEY UPDATE assignment_list]
value:
{expr | DEFAULT}
value_list:
value [, value] ...
assignment:
col_name = value
assignment_list:
assignment [, assignment] ...
DELETE陳述句
DELTE陳述句主要用來洗掉 MySQL 資料表中的記錄
語法格式
單表洗掉
DELETE [LOW_PRIORITY] [QUICK] [IGNORE] FROM tbl_name
[PARTITION (partition_name [, partition_name] ...)]
[WHERE where_condition]
[ORDER BY ...]
[LIMIT row_count]
多表洗掉
DELETE [LOW_PRIORITY] [QUICK] [IGNORE]
tbl_name[.*] [, tbl_name[.*]] ...
FROM table_references
[WHERE where_condition]
DELETE [LOW_PRIORITY] [QUICK] [IGNORE]
FROM tbl_name[.*] [, tbl_name[.*]] ...
USING table_references
[WHERE where_condition]
UPDATE陳述句
參考：UPDATE Syntax
UPDATE陳述句主要用于修改或更新資料表中的資料，
語法格式
單表更新
UPDATE [LOW_PRIORITY] [IGNORE] table_reference
SET assignment_list
[WHERE where_condition]
[ORDER BY ...]
[LIMIT row_count]
value:
{expr | DEFAULT}
assignment:
col_name = value
assignment_list:
assignment [, assignment] ...
多表更新
UPDATE [LOW_PRIORITY] [IGNORE] table_references
SET assignment_list
[WHERE where_condition]
SELECT陳述句
SELECT陳述句主要用來查詢資料表中的資料，
語法格式
SELECT
[ALL | DISTINCT | DISTINCTROW ]
[HIGH_PRIORITY]
[STRAIGHT_JOIN]
[SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT]
[SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS]
select_expr [, select_expr ...]
[FROM table_references
[PARTITION partition_list]
[WHERE where_condition]
[GROUP BY {col_name | expr | position}
[ASC | DESC], ... [WITH ROLLUP]]
[HAVING where_condition]
[ORDER BY {col_name | expr | position}
[ASC | DESC], ...]
[LIMIT {[offset,] row_count | row_count OFFSET offset}]
[PROCEDURE procedure_name(argument_list)]
[INTO OUTFILE 'file_name'
[CHARACTER SET charset_name]
export_options
| INTO DUMPFILE 'file_name'
| INTO var_name [, var_name]]
[FOR UPDATE | LOCK IN SHARE MODE]]
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/16400.html
標籤：MySQL
上一篇：MySQL基礎筆記
下一篇：instead of如何使用？