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/replication-features-auto-increment.html
Regardless of the method used to create and populate the copy having the AUTO_INCREMENT column, the final step is to drop the original table and then rename the copy: DROP t1; ALTER TABLE t2 RENAME t1; See also Section B.3.6.1, “Problems with ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-temptables.html
In statement-based replication mode, CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE statements cannot be used inside a transaction, procedure, function, or trigger when GTIDs are in use on the server (that is, when the enforce_gtid_consistency ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-triggers.html
If triggers for the table are added or dropped subsequent to the downgrade, the server rewrites the table's .TRG file. With statement-based replication, triggers executed on the source also execute on the replica. With row-based replication, ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-restrictions.html
When binlog_format is set to STATEMENT, CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE statements cannot be used inside transactions, procedures, functions, and triggers when GTIDs are in use on the server (that is, when the ... Because GTID-based ...
https://dev.mysql.com/doc/refman/8.0/en/show-profile.html
Note The SHOW PROFILE and SHOW PROFILES statements are deprecated; expect them to be removed in a future MySQL release. Use the Performance Schema instead; see Section 29.19.1, “Query Profiling Using Performance Schema”. To control profiling, ...
https://dev.mysql.com/doc/refman/8.0/en/show-warnings.html
SHOW WARNINGS [LIMIT [offset,] row_count] SHOW COUNT(*) WARNINGS SHOW WARNINGS is a diagnostic statement that displays information about the conditions (errors, warnings, and notes) resulting from executing a statement in the current session.
https://dev.mysql.com/doc/refman/8.0/en/signal.html
Signals can be raised within exception handlers: CREATE PROCEDURE p () BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN SIGNAL SQLSTATE VALUE '99999' SET MESSAGE_TEXT = 'An error occurred'; END; DROP TABLE no_such_table; END; CALL p() reaches the ...SIGNAL provides error information to a handler, to an outer portion of the application, or to the ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-reference-systems.html
DROP SPATIAL REFERENCE SYSTEM: See Section 15.1.31, “DROP SPATIAL REFERENCE SYSTEM Statement”. A spatial reference system (SRS) for spatial data is a coordinate-based system for geographic locations. There are different types of spatial ...
https://dev.mysql.com/doc/refman/8.0/en/uninstall-plugin.html
The table cannot even be opened, so you cannot drop an index for which the plugin is used. If you do not care about the table, DROP TABLE can be used even if any plugins associated with the table are missing. UNINSTALL PLUGIN plugin_name This ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-troubleshooting.html
To correct this, use DROP FUNCTION to drop the loadable function, and then use CREATE FUNCTION to re-create the loadable function with a different nonconflicting name. A schema mismatch in a MySQL 5.7 instance between the .frm file of a table and ...