PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-tips.html
Alternatively, create a shortcut that only sets the console font, and set the character set in the [mysql] group of your my.ini file: [mysql] default-character-set=utf8mb4 # or utf8mb3 Displaying Query Results Vertically Some query results are much ...In cases where a console is shared, this behavior may be ... This section provides information about techniques for ...
https://dev.mysql.com/doc/refman/8.0/en/security-against-attack.html
In any case, you should be very careful about creating grant table entries using host name values that contain wildcards. This is extremely dangerous, because any user with the FILE privilege is able to cause the server to create files as root (for ... When you connect to a MySQL server, you should use a ...
https://dev.mysql.com/doc/refman/8.0/en/aggregate-functions.html
For a faster count, create a counter table and let your application update it according to the inserts and deletes it does. InnoDB does not keep an internal count of rows in a table because concurrent transactions might “see” different numbers ... This section describes aggregate functions that operate on sets of ...
https://dev.mysql.com/doc/refman/8.0/en/miscellaneous-functions.html
Given this statement: CREATE TABLE t AS SELECT INET6_NTOA(expr) AS c1; The resulting table would have this definition: CREATE TABLE t (c1 VARCHAR(39) CHARACTER SET utf8mb3 DEFAULT NULL); The return string uses lowercase letters for IPv6 addresses.
https://dev.mysql.com/doc/refman/8.0/en/reloading-delimited-text-dumps.html
For backups produced with mysqldump --tab, each table is represented in the output directory by an .sql file containing the CREATE TABLE statement for the table, and a .txt file containing the table data. To reload a table, first change location ...
https://dev.mysql.com/doc/refman/8.0/en/subqueries.html
Beginning with MySQL 8.0.19, TABLE and VALUES statements can be used in subqueries. For information about how the optimizer handles subqueries, see Section 10.2.2, “Optimizing Subqueries, Derived Tables, View References, and Common Table ...All ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump-definition-data-dumps.html
The --no-data option tells mysqldump not to dump table data, resulting in the dump file containing only statements to create the tables. Conversely, the --no-create-info option tells mysqldump to suppress CREATE statements from the output, so that ...
https://dev.mysql.com/doc/refman/8.0/en/caching-sha2-pluggable-authentication.html
The following table shows the plugin names on the server and client sides. If caching_sha2_password is the default authentication plugin, a simpler CREATE USER syntax can be used. As a result, it is possible to create the account and set its ...
https://dev.mysql.com/doc/refman/8.0/en/copying-databases.html
In cases where you need to transfer databases between different architectures, you can use mysqldump to create a file containing SQL statements. Note If GTIDs are in use on the server where you create the dump (gtid_mode=ON), by default, mysqldump ...You can then transfer the file to the other machine and feed it as input to the mysql ...
https://dev.mysql.com/doc/refman/8.0/en/access-control.html
You cannot specify that a user has privileges to create or drop tables in a database but not to create or drop the database itself. MySQL enables the creation of accounts that permit client users to connect to the server and access data managed by ...The primary function of the MySQL privilege system is to authenticate a user who connects from a given host and to associate that user with privileges on a database such as SELECT, INSERT, UPDATE, and ...