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/charset.html
MySQL includes character set support that enables you to store data using a variety of character sets and perform comparisons according to a variety of collations. The default MySQL server character set and collation are utf8mb4 and ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-remote.html
mysql> SELECT FILE_NAME FROM INFORMATION_SCHEMA.FILES; Plugins that are active on the donor, including any keyring plugin, must also be active on the recipient. To view undo tablespace file names on the donor to ensure that they are unique, query ...
https://dev.mysql.com/doc/refman/8.0/en/compatibility.html
Selecting SQL Modes The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the value of the sql_mode system variable. This section describes how MySQL relates to the ANSI/ISO ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-like.html
To avoid the TABLESPACE attribute when creating an empty table based on the definition of such a table, use this syntax instead: CREATE TABLE new_tbl SELECT * FROM orig_tbl LIMIT 0; CREATE TABLE ... LIKE to create an empty table based on the ...
https://dev.mysql.com/doc/refman/8.0/en/create-temporary-table.html
The creating session can perform any operation on the table, such as DROP TABLE, INSERT, UPDATE, or SELECT. You can use the TEMPORARY keyword when creating a table. A TEMPORARY table is visible only within the current session, and is dropped ...
https://dev.mysql.com/doc/refman/8.0/en/creating-accounts.html
To manage MySQL accounts, use the SQL statements intended for that purpose: CREATE USER and DROP USER create and remove accounts. GRANT and REVOKE assign privileges to and revoke privileges from accounts. Account-management statements cause the ...
https://dev.mysql.com/doc/refman/8.0/en/cursors.html
Cursors have these properties: Asensitive: The server may or may not make a copy of its result table Read only: Not updatable Nonscrollable: Can be traversed only in one direction and cannot skip rows Cursor declarations must appear before handler ...
https://dev.mysql.com/doc/refman/8.0/en/data-type-defaults.html
SELECT, the destination table preserves expression default values from the original table. Data type specifications can have explicit or implicit default values. A DEFAULT value clause in a data type specification explicitly indicates a default ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-type-conversion.html
To some extent, you can convert a value from one temporal type to another. However, there may be some alteration of the value or loss of information. In all cases, conversion between temporal types is subject to the range of valid values for the ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-type-syntax.html
The date and time data types for representing temporal values are DATE, TIME, DATETIME, TIMESTAMP, and YEAR. For the DATE and DATETIME range descriptions, “supported” means that although earlier values might work, there is no guarantee. MySQL ...