PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/adding-character-set.html
<collation name="latin1_swedish_ci" id="8" order="Finnish, Swedish"> <flag>primary</flag> <flag>compiled</flag> </collation> <collation name="latin1_danish_ci" id="15" order="Danish"/> ... For each collation listed in the <charset> element for the ... This section discusses the procedure for adding a character set to ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-file-formats.html
The following statement displays the possible names: SELECT REPLACE(EVENT_NAME, 'statement/sql/', '') AS name FROM performance_schema.events_statements_summary_global_by_event_name WHERE EVENT_NAME LIKE 'statement/sql/%' ORDER BY name; ... The MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/charset-binary-collations.html
Binary strings are sequences of bytes and the numeric values of those bytes determine comparison and sort order. A given nonbinary character set can have several collations, each of which defines a particular comparison and sort order for the ...
https://dev.mysql.com/doc/refman/8.0/en/connection-access.html
When a client attempts to connect, the server looks through the rows in sorted order. The server uses sorting rules that order rows with the most-specific Host values first: Literal IP addresses and host names are the most specific. Rows with the ...
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 ...