PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/audit-log-reference.html
Return value: The password string for success (up to 766 bytes), or NULL and an error for failure. Return value: If the call succeeds, the return value is a binary JSON string containing an array of audit events, or a JSON null value if that was ...
https://dev.mysql.com/doc/refman/5.7/en/select-into.html
If the FIELDS ESCAPED BY character is empty, no characters are escaped and NULL is output as NULL, not \N. INTO form of SELECT enables a query result to be stored in variables or written to a file: SELECT ... Column and line terminators can be ...
https://dev.mysql.com/doc/refman/5.7/en/creating-tables.html
You want a table that contains a record for each of your pets. This can be called the pet table, and it should contain, as a bare minimum, each animal's name. Because the name by itself is not very interesting, the table should contain other ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-upgrade.html
--debug[=debug_options], -# [debug_options] Command-Line Format --debug[=#] Type String Default Value d:t:O,/tmp/mysql_upgrade.trace Write a debugging log. --default-auth=plugin Command-Line Format --default-auth=plugin Type String A hint about ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-pruning.html
Important Invalid DATE and DATETIME values referenced in the WHERE condition of a statement against a partitioned table are treated as NULL. The core concept behind partition pruning is relatively simple, and can be described as “Do not scan ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statement-performance-analyzer.html
If in_table is NULL and no snapshot exists, a new snapshot is created. Creates a report of the statements running on the server. The views are calculated based on the overall and/or delta activity. This procedure disables binary logging during its ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-applier-status-by-worker-table.html
After STOP SLAVE, the THREAD_ID column becomes NULL, but the WORKER_ID value is preserved. An error number of 0 and message of the empty string mean “no error”. If the replica is not multithreaded, this table shows the status of the applier ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-relation-functions-mbr.html
MBRCoveredBy() handles its arguments as follows: If either argument is NULL or an empty geometry, the return value is NULL. If either argument is not a syntactically well-formed geometry byte string, an ER_GIS_INVALID_DATA error occurs. MBRCovers() ... MySQL provides several MySQL-specific functions that test the relationship between minimum bounding rectangles (MBRs) of two geometries g1 and ...
https://dev.mysql.com/doc/refman/5.7/en/scalar-subqueries.html
A scalar subquery is a simple operand, and you can use it almost anywhere a single column value or literal is legal, and you can expect it to have those characteristics that all operands have: a data type, a length, an indication that it can be ...
https://dev.mysql.com/doc/refman/5.7/en/range-optimization.html
Additionally, for BTREE indexes, comparison of a key part with a constant value is a range condition when using the >, <, >=, <=, BETWEEN, !=, or <> operators, or LIKE comparisons if the argument to LIKE is a constant string that does not start with ... The range access method uses a single index to retrieve a subset of table rows that are contained within one or several index value ...