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-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
...
https://dev.mysql.com/doc/refman/8.0/en/what-is.html
...
https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html
Table creation and drop operations for any storage engine modify data dictionary tables in the mysql system database, but those tables use the InnoDB storage engine and cannot be modified when innodb_read_only is enabled. Some options, which you ...
https://dev.mysql.com/doc/refman/8.0/en/alter-user.html
ALTER USER Multifactor Authentication Options As of MySQL 8.0.27, ALTER USER has ADD, MODIFY, and DROP clauses that enable authentication factors to be added, modified, or dropped. When ALTER USER adds, modifies, or drops second and third factors in ... ALTER USER [IF EXISTS] user [auth_option] [, user [auth_option]] ...
https://dev.mysql.com/doc/refman/8.0/en/handler-scope.html
However, SQLSTATE handlers take precedence over SQLEXCEPTION handlers, so if the table t is nonexistent, the DROP TABLE statement raises a condition that activates the SQLSTATE handler: mysql> CALL p1(); +--------------------------------+ | msg | ...
https://dev.mysql.com/doc/refman/8.0/en/extensions-to-ansi.html
See Section 15.1.12, “CREATE DATABASE Statement”, Section 15.1.24, “DROP DATABASE Statement”, and Section 15.1.2, “ALTER DATABASE Statement”. Organization of data on disk MySQL Server maps each database to a directory under the MySQL ...
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/stored-objects-security.html
An existing stored object can become orphaned through execution of a DROP USER statement that drops the object DEFINER account, or a RENAME USER statement that renames the object DEFINER account. (That is, the statement fails if dropping an account ... Stored programs (procedures, functions, triggers, and events) and views are defined prior to use and, when referenced, execute within a security context that determines their ...