PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.3Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/stored-programs-logging.html
The statements used to create and drop procedures, functions, triggers, and events are always safe, and are logged in statement format. To create or alter a stored function, you must have the SET_USER_ID privilege (or the deprecated SUPER ... The ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-restore.html
This program reads the files created as a result of the backup and inserts the stored information into the database. ndb_restore must be executed once for each of the backup files that were created by the START BACKUP command used to create the ...
https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html
This change applies only to new accounts created after installing or upgrading to MySQL 8.0 or higher. However, the setting should be viewed as temporary, not as a long term or permanent solution, because it causes new accounts created with the ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table.html
For example, you can add or delete columns, create or destroy indexes, change the type of existing columns, or rename columns or the table itself. To use ALTER TABLE, you need ALTER, CREATE, and INSERT privileges for the table. Renaming a table ...
https://dev.mysql.com/doc/refman/8.0/en/atomic-ddl.html
Supported table DDL statements include CREATE, ALTER, and DROP statements for databases, tablespaces, tables, and indexes, and the TRUNCATE TABLE statement. Supported non-table DDL statements include: CREATE and DROP statements, and, if applicable, ...An atomic DDL statement combines the data dictionary updates, storage engine operations, and binary log writes associated with a DDL operation into a single, atomic ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-fulltext-index.html
Full-text indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to speed up queries and DML operations on data contained within those columns. A full-text index is defined as part of a CREATE TABLE statement or added to an ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-undo-tablespaces.html
Default undo tablespaces are created at initialization time to provide a location for rollback segments that must exist before SQL statements can be accepted. Default undo tablespaces are created in the location defined by the innodb_undo_directory ... Undo tablespaces contain undo logs, which are collections of records containing information about how to undo the latest change by a transaction to a clustered index ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-columns-range.html
However, the order of the column names in the partitioning column list and the value lists does not have to be the same as the order of the table column definitions in the main part of the CREATE TABLE statement. In addition, changing the character ... Range columns partitioning is similar to range partitioning, but enables you to define partitions using ranges based on multiple column ...
https://dev.mysql.com/doc/refman/8.0/en/load-data.html
The server creates a copy of the file in the directory where it stores temporary files. If you use LOAD DATA on an empty MyISAM table, all nonunique indexes are created in a separate batch (as for REPAIR TABLE). In some extreme cases, you can create ...The file can be read from the server host or the client host, depending on whether the LOCAL modifier is ...
https://dev.mysql.com/doc/refman/8.0/en/password-management.html
To establish policy for individual accounts, use the PASSWORD EXPIRE option of the CREATE USER and ALTER USER statements. See Section 15.7.1.3, “CREATE USER Statement”, and Section 15.7.1.1, “ALTER USER Statement”. Example account-specific ... MySQL supports these password-management capabilities: Password expiration, to require passwords to be changed ...