mysql - 随笔分类(第2页) - wongchaofan

隐式提交的语句

摘要：事务控制语句和锁语句也有例外：如果一个隐式提交发生在执行之前，那么其他的在之后也不会发生。 Data definition language (DDL) statements that define or modify database objects. ALTER DATABASE ... UPG 阅读全文

posted @ 2020-08-18 02:20 wongchaofan 阅读(288) 评论(0) 推荐(0)

START TRANSACTION, COMMIT, and ROLLBACK

摘要：https://dev.mysql.com/doc/refman/5.7/en/commit.html START TRANSACTION [transaction_characteristic [, transaction_characteristic] ...] transaction_char 阅读全文

posted @ 2020-08-18 01:57 wongchaofan 阅读(107) 评论(0) 推荐(0)

UPDATE Statement

摘要：UPDATE is a DML statement that modifies rows in a table. Single-table syntax: UPDATE [LOW_PRIORITY] [IGNORE] table_reference SET assignment_list [WHER 阅读全文

posted @ 2020-08-18 01:17 wongchaofan 阅读(253) 评论(0) 推荐(0)

子查询

摘要：不建议使用子查询，能用链接的用链接，子查询影响服务器性能。 SELECT * FROM t1 WHERE column1 = (SELECT column1 FROM t2); DELETE FROM t1 WHERE s11 > ANY (SELECT COUNT(*) /* no hint */ 阅读全文

posted @ 2020-08-18 00:37 wongchaofan 阅读(76) 评论(0) 推荐(0)

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 阅读(265) 评论(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 阅读(374) 评论(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 阅读(325) 评论(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 阅读(185) 评论(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 阅读(1363) 评论(0) 推荐(0)

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 阅读(84) 评论(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 阅读(115) 评论(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 阅读(344) 评论(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 阅读(557) 评论(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 阅读(88) 评论(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 阅读(765) 评论(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 阅读(900) 评论(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 阅读(273) 评论(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 阅读(272) 评论(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 阅读(812) 评论(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 阅读(548) 评论(0) 推荐(0)

wonchaofan

随笔分类 - mysql

公告