2020年8月18日
SELECT
摘要： SELECT [ALL | DISTINCT | DISTINCTROW ] [HIGH_PRIORITY] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT] [SQL_CACHE | SQL_NO_CAC 阅读全文
posted @ 2020-08-18 00:35 wongchaofan 阅读(256) 评论(0) 推荐(0) 编辑
REPLACE替换语句
摘要： REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] {VALUES | VALUE} (v 阅读全文
posted @ 2020-08-18 00:18 wongchaofan 阅读(357) 评论(0) 推荐(0) 编辑
LOAD XML
摘要： LOAD XML [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name' [REPLACE | IGNORE] INTO TABLE [db_name.]tbl_name [CHARACTER SET charset_name] [ROWS ID 阅读全文
posted @ 2020-08-18 00:13 wongchaofan 阅读(288) 评论(0) 推荐(0) 编辑
LOAD DATA
摘要： LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name' [REPLACE | IGNORE] INTO TABLE tbl_name [PARTITION (partition_name [, partition_name] 阅读全文
posted @ 2020-08-18 00:10 wongchaofan 阅读(167) 评论(0) 推荐(0) 编辑
INSERT 插入语句
摘要： INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] . 阅读全文
posted @ 2020-08-18 00:07 wongchaofan 阅读(1347) 评论(0) 推荐(0) 编辑
2020年8月17日
HANDLER Statement
摘要： HANDLER tbl_name OPEN [ [AS] alias] HANDLER tbl_name READ index_name { = | <= | >= | < | > } (value1,value2,...) [ WHERE where_condition ] [LIMIT ... 阅读全文
posted @ 2020-08-17 07:01 wongchaofan 阅读(74) 评论(0) 推荐(0) 编辑
DO Statement
摘要： DO expr [, expr] ... DO语句执行表达式但不返回任何结果。 mysql> SELECT SLEEP(5); + + | SLEEP(5) | + + | 0 | + + 1 row in set (5.02 sec) mysql> DO SLEEP(5); Query OK, 0 阅读全文
posted @ 2020-08-17 06:39 wongchaofan 阅读(107) 评论(0) 推荐(0) 编辑
DELETE Statement删除数据语句
摘要： Single-Table Syntax DELETE [LOW_PRIORITY] [QUICK] [IGNORE] FROM tbl_name [PARTITION (partition_name [, partition_name] ...)] [WHERE where_condition] [ 阅读全文
posted @ 2020-08-17 06:36 wongchaofan 阅读(334) 评论(0) 推荐(0) 编辑
CALL Statement调用存储过程
摘要： CALL sp_name([parameter[,...]]) CALL sp_name[()] CREATE PROCEDURE p (OUT ver_param VARCHAR(25), INOUT incr_param INT) BEGIN # Set value of OUT paramet 阅读全文
posted @ 2020-08-17 06:29 wongchaofan 阅读(546) 评论(0) 推荐(0) 编辑
重命名语句
摘要： RENAME TABLE RENAME TABLE tbl_name TO new_tbl_name [, tbl_name2 TO new_tbl_name2] ... RENAME TABLE old_table TO new_table; ALTER TABLE old_table RENAM 阅读全文
posted @ 2020-08-17 06:05 wongchaofan 阅读(82) 评论(0) 推荐(0) 编辑