Search Results
https://dev.mysql.com/doc/refman/8.4/en/temporary-table-problems.html
Temporary tables created with CREATE TEMPORARY TABLE have the following limitations: TEMPORARY tables are supported only by the InnoDB, MEMORY, MyISAM, and MERGE storage engines. Use ALTER TABLE instead: ALTER TABLE old_name RENAME new_name; You ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-generated-columns.html
It is permitted to mix VIRTUAL and STORED columns within a table. A function is deterministic if, given the same data in tables, multiple invocations produce the same result, independently of the connected user. A generated column definition can ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-utilities-table-export.html
MySQL Shell's table export utility util.exportTable() exports a MySQL relational table into a data file, either on the local server or in an Oracle Cloud Infrastructure Object Storage bucket. The data can then be uploaded into a table on a target ...Preset options are available to export CSV files for either DOS or UNIX systems, and TSV ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-explanations-ml-explain-table.html
ML_EXPLAIN_TABLE explains predictions for an entire table of unlabeled data. We recommend limiting the input table to a maximum of 100 rows. If the input table has more than ten columns, limit it to ten rows. Some of these columns include: ...The ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-files-table.html
The FILES table provides information about the files in which MySQL tablespace data is stored. In NDB Cluster, this table also provides information about the files in which NDB Cluster Disk Data tables are stored. The FILES table has these columns: ...For additional information specific to InnoDB, see InnoDB Notes, later in this section; for additional information specific to NDB Cluster, see NDB ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-threads-table.html
The threads table contains a row for each server thread. When the Performance Schema initializes, it populates the threads table based on the threads in existence then. The INSTRUMENTED and HISTORY column values for new threads are determined by ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-schema.html
ndb_apply_status Table ndb_binlog_index Table ndb_replication Table Replication in NDB Cluster makes use of a number of dedicated tables in the mysql database on each MySQL Server instance acting as an SQL node in both the cluster being replicated ...This is true regardless of whether the replica is a single server or a ...
https://dev.mysql.com/doc/refman/8.4/en/drop-table.html
Be careful with this statement! For each table, it removes the table definition and all table data. If the table is partitioned, the statement removes the table definition, all its partitions, all data stored in those partitions, and all partition ...They are permitted to make porting easier from other database ...
https://dev.mysql.com/doc/refman/8.4/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 29.12.20.5, “Transaction Summary ...
https://dev.mysql.com/doc/workbench/en/wb-tables-physical-schemata.html
Double-clicking the Add table icon in the Physical Schemas section of the Model Overview tab adds a table with the default name of table1. If a table with this name already exists, the new table is named table2. Adding a new table automatically ...