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/replication-gtids-concepts.html
A global transaction identifier (GTID) is a unique identifier created and associated with each transaction committed on the server of origin (the source). This identifier is unique not only to the server on which it originated, but is unique across ...
https://dev.mysql.com/doc/refman/5.7/en/selecting-rows.html
As shown in the preceding section, it is easy to retrieve an entire table. But typically you don't want to see the entire table, particularly when it becomes large. Instead, you're usually more interested in answering a particular question, in ...
https://dev.mysql.com/doc/refman/5.7/en/show-events.html
row *************************** Db: myschema Name: e_daily Definer: jon@ghidora Time zone: SYSTEM Type: RECURRING Execute at: NULL Interval value: 1 Interval field: DAY Starts: 2018-08-08 11:06:34 Ends: NULL Status: ENABLED Originator: 1 ... SHOW ...
https://dev.mysql.com/doc/refman/5.7/en/tracing-example.html
(Observe that it could have a match, were the operator a null-safe equals <=>). Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM ...
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/constraint-invalid-data.html
If you try to store NULL into a column that does not take NULL values, an error occurs for single-row INSERT statements. MySQL 5.7.5 and later uses strict SQL mode by default, which treats invalid values such that the server rejects them and aborts ...
https://dev.mysql.com/doc/refman/5.7/en/gis-geometrycollection-property-functions.html
If any argument is NULL or the geometry argument is an empty geometry, the return value is NULL. If the argument is NULL or an empty geometry, the return value is NULL. GeometryN() is deprecated; expect it to be removed in a future MySQL release.
https://dev.mysql.com/doc/refman/5.7/en/help.html
If X is less than or equal to 0.0E0, the function returns NULL and a warning "Invalid argument for logarithm" is reported. URL: https://dev.mysql.com/doc/refman/8.0/en/mathematical-functions.html Examples: mysql> SELECT LOG(2); -> 0.69314718055995 ... HELP 'search_string' The HELP statement returns online information from the MySQL Reference ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html
Information about table definitions is stored both in the .frm files, and in the InnoDB data dictionary. If you move .frm files around, or if the server crashes in the middle of a data dictionary operation, these sources of information can become ...
https://dev.mysql.com/doc/refman/5.7/en/insert.html
Warnings can occur under any of the following conditions: Inserting NULL into a column that has been declared NOT NULL. (For a single-row INSERT, no warning occurs when NULL is inserted into a NOT NULL column. INSERT [LOW_PRIORITY | DELAYED | ...