PDF (US Ltr)
- 41.9Mb
PDF (A4)
- 42.0Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/batch-mode.html
In the previous sections, you used mysql interactively to enter statements and view the results. If you want the script to continue even if some of the statements in it produce errors, you should use the --force command-line option. Why use a ...
https://dev.mysql.com/doc/refman/9.7/en/binary-log-mixed.html
When running in MIXED logging format, the server automatically switches from statement-based to row-based logging under the following conditions: When a function contains UUID(). When one or more tables with AUTO_INCREMENT columns are updated and a ...
https://dev.mysql.com/doc/refman/9.7/en/caching-sha2-pluggable-authentication.html
MySQL provides two authentication plugins that implement hashing for user account passwords: caching_sha2_password: Implements multiple hashing schemes based on the SHA2 family. It uses caching on the server side for better performance and has ...
https://dev.mysql.com/doc/refman/9.7/en/changing-mysql-user.html
On Windows, you can run the server as a Windows service using a normal user account. On Linux, for installations performed using a MySQL repository or RPM packages, the MySQL server mysqld should be started by the local mysql operating system user.
https://dev.mysql.com/doc/refman/9.7/en/channels-startup-options.html
This section describes startup options which are impacted by the addition of replication channels. The following startup options now affect all channels in a replication topology. --log-replica-updates All transactions received by the replica (even ...
https://dev.mysql.com/doc/refman/9.7/en/charset-database.html
Every database has a database character set and a database collation. The CREATE DATABASE and ALTER DATABASE statements have optional clauses for specifying the database character set and collation: CREATE DATABASE db_name [[DEFAULT] CHARACTER SET ...
https://dev.mysql.com/doc/refman/9.7/en/charset-examples.html
The following examples show how MySQL determines default character set and collation values. Example 1: Table and Column Definition CREATE TABLE t1 ( c1 CHAR(10) CHARACTER SET latin1 COLLATE latin1_german1_ci ) DEFAULT CHARACTER SET latin2 COLLATE ...
https://dev.mysql.com/doc/refman/9.7/en/charset-unicode-utf32.html
The utf32 character set is fixed length (like ucs2 and unlike utf16). utf32 uses 32 bits for every character, unlike ucs2 (which uses 16 bits for every character), and unlike utf16 (which uses 16 bits for some characters and 32 bits for others).
https://dev.mysql.com/doc/refman/9.7/en/charset-unicode-utf8.html
utf8 is a deprecated alias whose interpretation in SQL statements is controlled by the `INTERPRET_UTF8_AS_UTF8MB4` SQL mode. When the server stores or reports a resolved character set or collation, it uses the canonical `utf8mb3` or `utf8mb4` name ...
https://dev.mysql.com/doc/refman/9.7/en/charset-unicode-utf8mb3.html
The utf8mb3 character set has these characteristics: Supports BMP characters only (no support for supplementary characters) Requires a maximum of three bytes per multibyte character. Applications that use UTF-8 data but require supplementary ...