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-tzinfo-to-sql.html
The mysql_tzinfo_to_sql program loads the time zone tables in the mysql database. It is used on systems that have a zoneinfo database (the set of files describing time zones). One likely location for these files is the /usr/share/zoneinfo directory ...
https://dev.mysql.com/doc/refman/8.0/en/retrieving-data.html
The SELECT statement is used to pull information from a table. The general form of the statement is: SELECT what_to_select FROM which_table WHERE conditions_to_satisfy; what_to_select indicates what you want to see. This can be a list of columns, ...If it is present, conditions_to_satisfy specifies one or more conditions that rows must satisfy to qualify for ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-table-lock-waits.html
For additional information, see the description of the Performance Schema metadata_locks table at Section 29.12.13.3, “The metadata_locks Table”. The schema_table_lock_waits and x$schema_table_lock_waits views have these columns: object_schema ... These views display which sessions are blocked waiting on metadata locks, and what is blocking ...
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/fulltext-search.html
Full-text indexes can be used only with InnoDB or MyISAM tables, and can be created only for CHAR, VARCHAR, or TEXT columns. A FULLTEXT index definition can be given in the CREATE TABLE statement when a table is created, or added later using ALTER ...This rules out, for example, a table column because that can differ for each ... MATCH (col1,col2,...) AGAINST (expr [search_modifier]) search_modifier: { IN NATURAL LANGUAGE MODE | IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION | IN BOOLEAN MODE | WITH QUERY EXPANSION } MySQL has support for ...
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 ...