PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/insert.html
[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 ... 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)] ...
https://dev.mysql.com/doc/refman/5.7/en/json-attribute-functions.html
mysql> SELECT JSON_VALID('{"a": 1}'); +------------------------+ | JSON_VALID('{"a": 1}') | +------------------------+ | 1 | +------------------------+ mysql> SELECT JSON_VALID('hello'), JSON_VALID('"hello"'); ... The functions in this section ...
https://dev.mysql.com/doc/refman/5.7/en/load-data.html
INTO Statement”.) To write data from a table to a file, use SELECT ... For example, if you write a data file with mysqldump -T or by issuing a SELECT ... Field and Line Handling For both the LOAD DATA and SELECT ... For example, you can use IGNORE ...The file can be read from the server host or the client host, depending on whether the LOCAL modifier is ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-column-indexes.html
MySQL can create composite indexes (that is, indexes on multiple columns). For certain data types, you can index a prefix of the column (see Section 8.3.4, “Column Indexes”). MySQL can use multiple-column indexes for queries that test all the ...
https://dev.mysql.com/doc/refman/5.7/en/where-optimization.html
The examples use SELECT statements, but the same optimizations apply for WHERE clauses in DELETE and UPDATE statements. MySQL quickly detects that some SELECT statements are impossible and returns no rows. All of the following tables are used as ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-file-formats.html
To select the log format that the audit log plugin uses to write its log file, set the audit_log_format system variable at server startup. Note For information about issues to consider when changing the log format, see Selecting Audit Log File ...
https://dev.mysql.com/doc/refman/5.7/en/counting-rows.html
COUNT(*) counts the number of rows, so the query to count your animals looks like this: mysql> SELECT COUNT(*) FROM pet; +----------+ | COUNT(*) | +----------+ | 9 | +----------+ Earlier, you retrieved the names of the people who owned pets.
https://dev.mysql.com/doc/refman/5.7/en/exists-and-not-exists-subqueries.html
For example: SELECT column1 FROM t1 WHERE EXISTS (SELECT * FROM t2); Traditionally, an EXISTS subquery starts with SELECT *, but it could begin with SELECT 5 or SELECT column1 or anything at all. MySQL ignores the SELECT list in such a subquery, so ... If a subquery returns any rows at all, EXISTS subquery is TRUE, and NOT EXISTS subquery is ...
https://dev.mysql.com/doc/refman/5.7/en/explain-extended.html
For SELECT statements, the EXPLAIN statement produces extra (“extended”) information that is not part of EXPLAIN output but can be viewed by issuing a SHOW WARNINGS statement following EXPLAIN. The Message value in SHOW WARNINGS output displays ...SHOW WARNINGS displays an empty result for other explainable statements (DELETE, INSERT, REPLACE, and ...
https://dev.mysql.com/doc/refman/5.7/en/firewall-usage.html
For example: SELECT first_name, last_name FROM customer WHERE customer_id = 1; UPDATE rental SET return_date = NOW() WHERE rental_id = 1; SELECT get_customer_balance(1, NOW()); Because the profile is in RECORDING mode, the firewall records the ...