摘要: 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 阅读(108) 评论(0) 推荐(0) 编辑
摘要: 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 阅读(337) 评论(0) 推荐(0) 编辑
摘要: 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 阅读(547) 评论(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 阅读(83) 评论(0) 推荐(0) 编辑
摘要: CREATE TRIGGER CREATE [DEFINER = user] TRIGGER trigger_name trigger_time trigger_event ON tbl_name FOR EACH ROW [trigger_order] trigger_body trigger_t 阅读全文
posted @ 2020-08-17 06:00 wongchaofan 阅读(755) 评论(0) 推荐(0) 编辑
摘要: CREATE VIEW CREATE [OR REPLACE] [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}] [DEFINER = user] [SQL SECURITY { DEFINER | INVOKER }] VIEW view_name [(c 阅读全文
posted @ 2020-08-17 05:57 wongchaofan 阅读(891) 评论(0) 推荐(0) 编辑
摘要: CREATE TABLESPACE CREATE TABLESPACE tablespace_name InnoDB and NDB: ADD DATAFILE 'file_name' InnoDB only: [FILE_BLOCK_SIZE = value] NDB only: USE LOGF 阅读全文
posted @ 2020-08-17 05:54 wongchaofan 阅读(264) 评论(0) 推荐(0) 编辑
摘要: CREATE LOGFILE GROUP CREATE LOGFILE GROUP logfile_group ADD UNDOFILE 'undo_file' [INITIAL_SIZE [=] initial_size] [UNDO_BUFFER_SIZE [=] undo_buffer_siz 阅读全文
posted @ 2020-08-17 05:51 wongchaofan 阅读(265) 评论(0) 推荐(0) 编辑
摘要: CREATE INDEX CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_opt 阅读全文
posted @ 2020-08-17 05:16 wongchaofan 阅读(800) 评论(0) 推荐(0) 编辑
摘要: CREATE PROCEDURE and CREATE FUNCTION CREATE [DEFINER = user] PROCEDURE sp_name ([proc_parameter[,...]]) [characteristic ...] routine_body CREATE [DEFI 阅读全文
posted @ 2020-08-17 05:13 wongchaofan 阅读(537) 评论(0) 推荐(0) 编辑