PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/getting-information.html
You can obtain the CREATE TABLE statement necessary to create an existing table using the SHOW CREATE TABLE statement. What if you forget the name of a database or table, or what the structure of a given table is (for example, what its columns are ...You have previously seen SHOW DATABASES, which lists the databases managed by the ...
https://dev.mysql.com/doc/refman/8.0/en/federated-usagenotes.html
It is possible for one FEDERATED table to point to another, but you must be careful not to create a loop. Care should be taken when creating a FEDERATED table since the index definition from an equivalent MyISAM or other table may not be supported.
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-transactions.html
When a user-created NDB table is accessed using a unique index, the hidden index table is first read to find the primary key that is then used to read the user-created table. When a row referenced by a unique index in the user-created NDB table is ...NDBCLUSTER stores only part of a column value that uses any of MySQL's BLOB or TEXT data types in the table visible to MySQL; the remainder of the BLOB or TEXT is stored in a separate internal table that is not accessible to ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-import.html
db_name is the name of the database where the table into which to import the data is found; file_name is the name of the CSV file from which to read the data; this must include the path to this file if it is not in the current directory. The name of ... ndb_import imports CSV-formatted data, such as that produced by mysqldump --tab, directly into NDB using the NDB ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-qualifiers.html
For example, this statement creates a table using the unqualified name t1: CREATE TABLE t1 (i INT); Because t1 includes no qualifier to specify a database, the statement creates the table in the default database. This statement creates a table using ...ON mydb.mytable ...; A column name may be given multiple qualifiers to indicate context in statements that reference it, as shown in the following ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-examples.html
Note This section describes locking information as exposed by the Performance Schema data_locks and data_lock_waits tables, which supersede the INFORMATION_SCHEMA INNODB_LOCKS and INNODB_LOCK_WAITS tables in MySQL 8.0. For similar discussion ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-blobs.html
The part and (NDB 8.0.30 and later) inline sizes of NDB blob columns can be set using CREATE TABLE and ALTER TABLE statements containing NDB table column comments (see NDB_COLUMN Options); this can also be done in NDB API applications (see ...Parts ...For more information about how NDB Cluster stores columns of such types, see String Type Storage ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-key.html
PARTITION BY KEY are similar to those for creating a table that is partitioned by hash. In both of these cases, the partitioning key is the id column, even though it is not shown in the output of SHOW CREATE TABLE or in the PARTITION_EXPRESSION ...
https://dev.mysql.com/doc/refman/8.0/en/stored-program-restrictions.html
(Bug #16396) References to stored functions, loadable functions, and tables in the ON SCHEDULE clauses of CREATE EVENT and ALTER EVENT statements are not supported. Any stored routine or trigger that interacts with MySQL Cluster tables must be ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-selection.html
When a table is created using [LINEAR] HASH or [LINEAR] KEY partitioning and the names of the partitions are not specified, MySQL automatically names the partitions p0, p1, p2, ..., pN-1, where N is the number of partitions. This option always ...