PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/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 ...While the procedure executes, the session uses the privileges of the defining ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-objects-table.html
The setup_objects table controls whether the Performance Schema monitors particular objects. This table has a maximum size of 100 rows by default. To change the table size, modify the performance_schema_setup_objects_size system variable at server ...The order in which matching occurs matters because different matching setup_objects rows can have different ENABLED and TIMED ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-privilege-distribution.html
After the copies are created, mysql_cluster_move_privileges invokes mysql_cluster_move_grant_tables, which contains the ALTER TABLE ... Normally, each MySQL server's user privilege tables in the mysql database must use the MyISAM storage engine, ...
https://dev.mysql.com/doc/refman/5.7/en/implicit-commit.html
(ALTER FUNCTION can only be used with stored functions.) CREATE TABLE and DROP TABLE statements do not commit a transaction if the TEMPORARY keyword is used. (This does not apply to other operations on temporary tables such as ALTER TABLE and CREATE ...ALTER FUNCTION, CREATE FUNCTION and DROP FUNCTION also cause an implicit commit when used with stored functions, but not with loadable ... The statements listed in this section (and ...
https://dev.mysql.com/doc/refman/5.7/en/join.html
MySQL supports the following JOIN syntax for the table_references part of SELECT statements and multiple-table DELETE and UPDATE statements: table_references: escaped_table_reference [, escaped_table_reference] ... A table reference (when it refers ...index_hint: { USE {INDEX|KEY} [FOR {JOIN|ORDER BY|GROUP BY}] ([index_list]) | {IGNORE|FORCE} {INDEX|KEY} [FOR {JOIN|ORDER BY|GROUP BY}] (index_list) } index_list: index_name [, index_name] ...
https://dev.mysql.com/doc/refman/5.7/en/temporary-table-problems.html
Use ALTER TABLE instead: ALTER TABLE old_name RENAME new_name; You cannot refer to a TEMPORARY table more than once in the same query. Temporary tables created with CREATE TEMPORARY TABLE have the following limitations: TEMPORARY tables are ...
https://dev.mysql.com/doc/refman/5.7/en/checksum-table.html
[QUICK | EXTENDED] CHECKSUM TABLE reports a checksum for the contents of a table. If you run CHECKSUM TABLE against a view, the Checksum value is always NULL, and a warning is returned. For a nonexistent table, CHECKSUM TABLE returns NULL and ...You ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-table-close.html
Each MyISAM index file (.MYI file) has a counter in the header that can be used to check whether a table has been closed properly. If you get the following warning from CHECK TABLE or myisamchk, it means that this counter has gone out of sync: ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-transaction-tables.html
These tables store transaction events: events_transactions_current: The current transaction event for each thread. There are also summary tables that aggregate information about transaction events; see Section 25.12.15.4, “Transaction Summary ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-introduction.html
INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access privileges. They are actually views, not base tables, so there are no files ...