Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-temporary-table.html
You can use the TEMPORARY keyword when creating a table. A TEMPORARY table is visible only within the current session, and is dropped automatically when the session is closed. This means that two different sessions can use the same temporary table ...
https://dev.mysql.com/doc/refman/8.4/en/drop-spatial-reference-system.html
DROP SPATIAL REFERENCE SYSTEM [IF EXISTS] srid srid: 32-bit unsigned integer This statement removes a spatial reference system (SRS) definition from the data dictionary. Example: DROP SPATIAL REFERENCE SYSTEM 4120; If no SRS definition with the ...
https://dev.mysql.com/doc/refman/8.4/en/open.html
OPEN cursor_name This statement opens a previously declared cursor. For an example, see Section 15.6.6, “Cursors”. ...
https://dev.mysql.com/doc/refman/8.4/en/set-character-set.html
SET {CHARACTER SET | CHARSET} {'charset_name' | DEFAULT} This statement maps all strings sent between the server and the current client with the given mapping. SET CHARACTER SET sets three session system variables: character_set_client and ...
https://dev.mysql.com/doc/refman/8.4/en/set-names.html
SET NAMES {'charset_name' [COLLATE 'collation_name'] | DEFAULT} This statement sets the three session system variables character_set_client, character_set_connection, and character_set_results to the given character set. Setting ...
https://dev.mysql.com/doc/refman/8.4/en/show-binary-log-status.html
SHOW BINARY LOG STATUS This statement provides status information about binary log files on the source server, and requires the REPLICATION CLIENT privilege (or the deprecated SUPER privilege). row *************************** File: ...
https://dev.mysql.com/doc/refman/8.4/en/show-master-status.html
This statement is no longer supported, and has been replaced by SHOW BINARY LOG STATUS.
https://dev.mysql.com/doc/refman/8.4/en/sys-statement-performance-analyzer.html
Creates a report of the statements running on the server. The default is to make a snapshot of the current content of the Performance Schema events_statements_summary_by_digest table. The in_views parameter and the ...The views are calculated based ...
https://dev.mysql.com/doc/refman/8.4/en/show-engines.html
SHOW [STORAGE] ENGINES SHOW ENGINES displays status information about the server's storage engines. This is particularly useful for checking whether a storage engine is supported, or to see what the default engine is. For information about MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/view-updatability.html
Some views are updatable and references to them can be used to specify tables to be updated in data change statements. That is, you can use them in statements such as UPDATE, DELETE, or INSERT to update the contents of the underlying table. Derived ...Generally, the view references must be updatable, meaning that they may be merged and not ...