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/trigger-syntax.html
To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 15.1.22, “CREATE TRIGGER Statement”, and Section 15.1.34, “DROP TRIGGER Statement”. You must specify the schema name if the ...
https://dev.mysql.com/doc/refman/8.0/en/truncate-table.html
Logically, TRUNCATE TABLE is similar to a DELETE statement that deletes all rows, or a sequence of DROP TABLE and CREATE TABLE statements. It differs from DELETE in the following ways: Truncate operations drop and re-create the table, which is much ...To achieve high performance, TRUNCATE TABLE bypasses the DML method of deleting ...
https://dev.mysql.com/doc/refman/8.0/en/added-deprecated-removed.html
clone_delay_after_data_drop: The time delay in seconds before the clone process starts. replica_parallel_type: Tells replica to use timestamp information (LOGICAL_CLOCK) or database partitioning (DATABASE) to parallelize transactions. Options and ...
https://dev.mysql.com/doc/refman/8.0/en/stored-programs-logging.html
The binary log contains information about SQL statements that modify database contents. These events bring databases up to date from the point of the backup. The statements used to create and drop procedures, functions, triggers, and events are ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-move-data.html
Usage The program is invoked with the names of the source and target tables; either or both of these may be qualified optionally with the database name. --database=dbname, -d Command-Line Format --database=name Type String Default Value TEST_DB Name ...ndb_move_data options source target Options that can be used with ndb_move_data are shown in the following ...
https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html
Data Dictionary Changes caching_sha2_password as the Preferred Authentication Plugin Configuration Changes Server Changes InnoDB Changes SQL Changes Changed Server Defaults Valid Performance Regressions Data Dictionary Changes MySQL Server 8.0 ...
https://dev.mysql.com/doc/refman/8.0/en/stored-routines-privileges.html
The ALTER ROUTINE privilege is needed to alter or drop stored routines. This privilege is granted automatically to the creator of a routine if necessary, and dropped from the creator when the routine is dropped. However, this privilege is granted ...
https://dev.mysql.com/doc/refman/8.0/en/view-restrictions.html
(This is another reason you might wish to force MySQL to use the temptable algorithm by specifying ALGORITHM = TEMPTABLE in the view definition.) You can use DROP TABLE or ALTER TABLE to drop or alter a table that is used in a view definition. No ...
https://dev.mysql.com/doc/refman/8.0/en/events-privileges.html
An event is not migrated or dropped as a result of renaming or dropping the user who created it. The same would be true if root had issued either of these statements: DROP USER jon@ghidora; RENAME USER jon@ghidora TO someotherguy@ghidora; You can ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-invoked.html
The following statements are replicated using statement-based replication: CREATE EVENT ALTER EVENT DROP EVENT CREATE PROCEDURE DROP PROCEDURE CREATE FUNCTION DROP FUNCTION CREATE TRIGGER DROP TRIGGER However, the effects of features created, ...