PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.3Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/create-spatial-reference-system.html
Attributes for the statement must satisfy these conditions: Attributes can be given in any order, but no attribute can be given more than once. However, if there are no AXIS clauses, MySQL cannot determine whether a definition has axes in ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-foreign-keys.html
In the referencing table, there must be an index where the foreign key columns are listed as the first columns in the same order. However, in the referenced table, there must be an index where the referenced columns are the first columns in the same ... MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data ...
https://dev.mysql.com/doc/refman/8.0/en/date-calculations.html
MySQL provides several functions that you can use to perform calculations on dates, for example, to calculate ages or extract parts of dates. To determine how many years old each of your pets is, use the TIMESTAMPDIFF() function. Its arguments are ...
https://dev.mysql.com/doc/refman/8.0/en/enum.html
Using ENUM columns in ORDER BY clauses requires extra care, as explained in Enumeration Sorting. Enumeration Sorting ENUM values are sorted based on their index numbers, which depend on the order in which the enumeration members were listed in the ... An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-table-import.html
Prior to MySQL 8.0.19, index key part sort order information is not stored to the .cfg metadata file used during a tablespace import operation. The index key part sort order is therefore assumed to be ascending, which is the default. As a result, ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-options-variables.html
The --ndb-nodeid option overrides any node ID set with --ndb-connectstring, regardless of the order in which the two options are used. In order for a join to be pushable, it must meet the following conditions: Only columns can be compared, and all ... This section provides information about MySQL server options, server and status variables that are specific to NDB ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-javascript-table-select.html
| Zeleznogorsk | RUS | +-------------------+-------------+ 29 rows in set (0.01 sec) Limit, Order, and Offset Results You can apply the limit(), orderBy(), and offSet() methods to manage the number and order of records returned by the select() ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-python-table-select.html
| Zeleznogorsk | RUS | +-------------------+-------------+ 29 rows in set (0.01 sec) Limit, Order, and Offset Results You can apply the limit(), order_by(), and offset() methods to manage the number and order of records returned by the select() ...
https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html
The restriction is necessary because collations used by various data dictionary table fields are based on the lower_case_table_names setting that was defined when the server was initialized, and restarting the server with a different setting would ... Before upgrading to MySQL 8.0, review the changes described in this section to identify those that apply to your current MySQL installation and ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log.html
If you disable binary logging, either omit these options, or specify --log-slave-updates=OFF and --skip-slave-preserve-commit-order. If you specify --log-slave-updates or --slave-preserve-commit-order together with --skip-log-bin or ... The binary ...