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/mysqlbinlog.html
There is an exception for CREATE DATABASE, ALTER DATABASE, and DROP DATABASE. The database being created, altered, or dropped is considered to be the default database when determining whether to output the statement. The server's binary log ...To ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump-sql-format.html
If you want to cause the dump file to force a drop of each database before recreating it, use the --add-drop-database option as well. In this case, mysqldump writes a DROP DATABASE statement preceding each CREATE DATABASE statement. Because the ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlshow.html
The mysqlshow client can be used to quickly see which databases exist, their tables, or a table's columns or indexes. Invoke mysqlshow like this: mysqlshow [options] [db_name [tbl_name [col_name]]] If no database is given, a list of database names ...The same information can be obtained by using those statements ...
https://dev.mysql.com/doc/refman/8.0/en/creating-many-tables.html
If you have many MyISAM tables in the same database directory, open, close, and create operations are slow. If you execute SELECT statements on many different tables, there is a little overhead when the table cache is full, because for every table ...
https://dev.mysql.com/doc/refman/8.0/en/other-vendor-data-types.html
These mappings make it easier to import table definitions from other database systems into MySQL. To facilitate the use of code written for SQL implementations from other vendors, MySQL maps data types as shown in the following table. If you create ...
https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption-installation.html
The CREATE FUNCTION and DROP FUNCTION statements require the INSERT and DROP privilege, respectively, for the mysql database. When you are upgrading, before installing the component, you must unload the legacy functions using the DROP FUNCTION ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-javascript-download.html
As part of this quick-start guide, an example schema is provided which is referred to as the world_x schema. Many of the examples demonstrate Document Store functionality using this schema. Start your MySQL server so that you can load the world_x ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-python-download.html
As part of this quick-start guide, an example schema is provided which is referred to as the world_x schema. Many of the examples demonstrate Document Store functionality using this schema. Start your MySQL server so that you can load the world_x ...
https://dev.mysql.com/doc/refman/8.0/en/permission-optimization.html
The more complex your privilege setup, the more overhead applies to all SQL statements. Simplifying the privileges established by GRANT statements enables MySQL to reduce permission-checking overhead when clients execute statements. For example, if ...
https://dev.mysql.com/doc/refman/8.0/en/sql-server-administration-statements.html
...