Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-columns-table.html
For information about generated columns, see Section 15.1.20.8, “CREATE TABLE and Generated Columns”. You can cause such information to be hidden by setting show_gipk_in_create_table_and_information_schema = OFF. The related ST_GEOMETRY_COLUMNS ...ORDINAL_POSITION is necessary because you might want to say ORDER BY ...
https://dev.mysql.com/doc/workbench/en/wb-preferences-modeling.html
Model Table Defaults Default Storage Engine: Tables created in MySQL Workbench are defined using this default storage engine. Figure 3.12 Preferences: Modeling: Defaults The following tables show the object names and their default values. Figure ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-scanning-basic.html
This example makes use of the following classes and methods: Ndb_cluster_connection: connect() wait_until_ready() Ndb: init() getDictionary() startTransaction() closeTransaction() NdbTransaction: getNdbScanOperation() execute() NdbOperation: ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-encoding-string-columns.html
For example: mysql> SELECT COLUMN_NAME, COLUMN_COMMENT FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME LIKE 'airline_info' AND COLUMN_COMMENT LIKE '%ENCODING%'; +-------------+------------------------------+ | COLUMN_NAME | COLUMN_COMMENT | ...The ... This topic describes how to encode string columns to improve the performance of queries that access ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-and-mysql-replication.html
For example, you can replicate modifications to an InnoDB table on the source to a MyISAM table on the replica. Cascading actions for InnoDB tables on the source are executed on the replica only if the tables sharing the foreign key relation use ...
https://dev.mysql.com/doc/refman/8.4/en/drop-tablespace.html
DROP [UNDO] TABLESPACE tablespace_name This statement drops a tablespace that was previously created using CREATE TABLESPACE. Only undo tablespaces created using CREATE UNDO TABLESPACE syntax can be dropped. Similar to the system tablespace, ...The ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-virtual-table.html
CREATE TABLE `t1` ( `a` int(11) DEFAULT NULL, `b` int(11) DEFAULT NULL, `c` int(11) GENERATED ALWAYS AS (5) VIRTUAL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; However, metadata for such a column does appear in the INNODB_COLUMNS table. The ...The ...
https://dev.mysql.com/doc/refman/8.4/en/nontransactional-tables.html
This can happen if you try to create a table using a transactional storage engine that is not supported by your mysqld server (or that was disabled with a startup option). If mysqld does not support a storage engine, it instead creates the table as ... If you receive the following message when trying to perform a ROLLBACK, it means that one or more of the tables you used in the transaction do not support transactions: Warning: Some non-transactional changed tables couldn't be rolled back These nontransactional tables are not affected by the ROLLBACK ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-myisam-category.html
Myisam Data Pointer Size The default pointer size, in bytes, to be used by CREATE TABLE for MyISAM tables when no MAX_ROWS option is specified. Myisam Max Sort File Size The maximum size of the temporary file that MySQL is permitted to use while ...
https://dev.mysql.com/doc/refman/8.4/en/charset-column.html
CREATE TABLE t1 ( col1 CHAR(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ) CHARACTER SET latin1 COLLATE latin1_bin; The character set and collation are specified for the column, so they are used. CREATE TABLE t1 ( col1 CHAR(10) CHARACTER SET ...To see the default collation for each character set, use the SHOW CHARACTER SET statement or query the INFORMATION_SCHEMA CHARACTER_SETS ... Every ...