Search Results
https://dev.mysql.com/doc/workbench/en/wb-sql-editor-navigator.html
A new table with the imported fields is created in the selected schema, unless you select the append or update (overwrite) option. This also has a simpler and easier to use interface for analyzing and creating indexes for tables. Create Table: ...To ... The Navigator area of the sidebar contains options to manage the active MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/server-options.html
--initialize, -I Command-Line Format --initialize[={OFF|ON}] Type Boolean Default Value OFF This option is used to initialize a MySQL installation by creating the data directory and populating the tables in the mysql system schema. The server ...
https://dev.mysql.com/doc/refman/8.4/en/invisible-columns.html
However, even if explicitly referenced, a column that is invisible in the existing table is visible in the new table: mysql> CREATE TABLE t1 (col1 INT, col2 INT INVISIBLE); mysql> CREATE TABLE t2 AS SELECT col1, col2 FROM t1; mysql> SHOW CREATE ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-mysql-cluster.html
You must also remember to account for any column indexes as follows: Each primary key or hash index created for an NDBCLUSTER table requires 21−25 bytes per record. Creating NDB Cluster tables with USING HASH for all primary keys and unique ...Can ... In the following section, we answer questions that are frequently asked about MySQL NDB Cluster and the NDB storage ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-table-privileges-table.html
The TABLE_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is granted, in 'user_name'@'host_name' format. TABLE_CATALOG The name of the catalog to which the table belongs. TABLE_SCHEMA The name of the schema ...The output does not list GRANT OPTION as a separate row with PRIVILEGE_TYPE='GRANT ...
https://dev.mysql.com/doc/refman/8.4/en/myisampack.html
(myisampack creates an intermediate file named tbl_name.TMD in the database directory while it compresses the table. When the table is used later, the server reads into memory the information needed to decompress columns. MySQL uses mmap() when ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-load-event-based.html
If you create the table manually, you can use the CREATE EXTERNAL TABLE command to set it up before loading data into the table. The following example uses Auto Parallel Load to automatically create a new table and set up a stream. mysql> SET ... As ...
https://dev.mysql.com/doc/workbench/en/wb-tables-physical-schemata.html
Copy SQL to Clipboard: Copies a CREATE TABLE statement for the table. 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 ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-analyzing-tables.html
When the secondary engine creates the ACE statistics model, the ACE_MODEL column is updated in the performance schema table rpd_tables. As of MySQL 9.3.0, you can use the ANALYZE TABLE statement to analyze tables loaded into MySQL HeatWave and ...
https://dev.mysql.com/doc/refman/8.4/en/set-operations.html
Result Set Column Names and Data Types Set Operations with TABLE and VALUES Statements Set Operations using DISTINCT and ALL Set Operations with ORDER BY and LIMIT Limitations of Set Operations SQL set operations combine the results of multiple ...