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/cannot-roll-back.html
In general, these include data definition language (DDL) statements, such as those that create or drop databases, those that create, drop, or alter tables or stored routines. If you issue a statement early in a transaction that cannot be rolled ...
https://dev.mysql.com/doc/refman/8.0/en/charset-binary-set.html
The binary character set is the character set for binary strings, which are sequences of bytes. Comparison and sorting are based on numeric byte values, rather than on numeric character code values (which for multibyte characters differ from ...For ...
https://dev.mysql.com/doc/refman/8.0/en/charset-charsets.html
To avoid choosing the wrong collation, it can be helpful to perform some comparisons with representative data values to make sure that a given collation sorts values the way you expect. There is one subsection for each group of related character ...
https://dev.mysql.com/doc/refman/8.0/en/charset-mysql.html
To avoid choosing an inappropriate collation, perform some comparisons with representative data values to make sure that a given collation sorts values the way you expect. To display the available character sets, use the INFORMATION_SCHEMA ... MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/charset-national.html
For example, these data type declarations are equivalent: CHAR(10) CHARACTER SET utf8 NATIONAL CHARACTER(10) NCHAR(10) As are these: VARCHAR(10) CHARACTER SET utf8 NATIONAL VARCHAR(10) NVARCHAR(10) NCHAR VARCHAR(10) NATIONAL CHARACTER VARYING(10) ...
https://dev.mysql.com/doc/refman/8.0/en/charset-syntax.html
There are default settings for character sets and collations at four levels: server, database, table, and column. Character set issues affect not only data storage, but also communication between client programs and the MySQL server. The ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-utf8mb4.html
The utf8mb4 character set has these characteristics: Supports BMP and supplementary characters. utf8mb4 contrasts with the utf8mb3 character set, which supports only BMP characters and uses a maximum of three bytes per character: For a BMP ...
https://dev.mysql.com/doc/refman/8.0/en/choosing-types.html
For optimum storage, you should try to use the most precise type in all cases. For example, if an integer column is used for values in the range from 1 to 99999, MEDIUMINT UNSIGNED is the best type. Of the types that represent all the required ...
https://dev.mysql.com/doc/refman/8.0/en/document-store-interfaces.html
To work with MySQL as a document store, you use dedicated components and a choice of clients that support communicating with the MySQL server to develop document based applications. You can use MySQL Shell to prototype applications, execute queries ...Installing MySQL Shell has instructions to download and install MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/event-scheduler.html
Section 27.4.4, “Event Metadata”, shows how to obtain information about events and how this information is stored by the MySQL Server. Stored routines require the events data dictionary table in the mysql system database. If you are upgrading to ... The MySQL Event Scheduler manages the scheduling and execution of events, that is, tasks that run according to a ...