Search Results
https://dev.mysql.com/doc/refman/8.4/en/alter-table-examples.html
row *************************** Table: t1 Create Table: CREATE TABLE `t2` ( `c1` int(11) DEFAULT NULL ) /*!50100 TABLESPACE ts_1 STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1 row in set (0.01 sec) To change ...For NDB tables, it is also possible to change the storage type used for a table or ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-gipks.html
row *************************** Table: auto_0 Create Table: CREATE TABLE `auto_0` ( `c1` varchar(50) DEFAULT NULL, `c2` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1 row in set (0.00 sec) mysql> SHOW CREATE ...
https://dev.mysql.com/doc/refman/8.4/en/extended-show.html
Some extensions to SHOW statements accompany the implementation of INFORMATION_SCHEMA: SHOW can be used to get information about the structure of INFORMATION_SCHEMA itself. Several SHOW statements accept a WHERE clause that provides more ...
https://dev.mysql.com/doc/refman/8.4/en/invisible-columns.html
row *************************** Table: t2 Create Table: CREATE TABLE `t2` ( `col1` int DEFAULT NULL, `col2` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci If invisibility should be preserved, provide a definition ...An invisible column is normally hidden to queries, but can be accessed if explicitly ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-command-options.html
It also disables all mysql commands except charset and delimiter in noninteractive mode (for input piped to mysql or loaded using the source command). --default-character-set=charset_name Command-Line Format --default-character-set=charset_name Type ... mysql supports the following options, which can be specified on the command line or in the [mysql] and [client] groups of an option ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlbinlog.html
--set-charset=charset_name Command-Line Format --set-charset=charset_name Type String Add a SET NAMES charset_name statement to the output to specify the character set to be used for processing log files. The server's binary log consists of files ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-range-list.html
Adding and dropping of range and list partitions are handled in a similar fashion, so we discuss the management of both sorts of partitioning in this section. For information about working with tables that are partitioned by hash or key, see ...
https://dev.mysql.com/doc/refman/8.4/en/show-character-set.html
SHOW {CHARACTER SET | CHARSET} [LIKE 'pattern' | WHERE expr] The SHOW CHARACTER SET statement shows all available character sets. The LIKE clause, if present, indicates which character set names to match. The WHERE clause can be given to select ...
https://dev.mysql.com/doc/refman/8.4/en/show-create-table.html
row *************************** Table: t Create Table: CREATE TABLE `t` ( `id` int NOT NULL AUTO_INCREMENT, `s` char(60) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci SHOW CREATE TABLE displays ... SHOW CREATE TABLE tbl_name Shows the CREATE TABLE statement that creates the named ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-connection.html
Default Value CATALOG Since Version 8.0.17 detectCustomCollations Should the driver detect custom charsets/collations installed on server? If this option set to "true" the driver gets actual charsets/collations from the server each time a connection ... connectionAttributes A comma-delimited list of user-defined "key:value" pairs, in addition to standard MySQL-defined "key:value" pairs, to be passed to MySQL Server for display as connection attributes in the 'PERFORMANCE_SCHEMA' tables 'session_account_connect_attrs' and ...