Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-table.html
(Some valid select or union statement) CREATE TABLE creates a table with the given name. By default, tables are created in the default database, using the InnoDB storage engine. For information about the physical representation of a table, see ...An ...| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-files.html
For an InnoDB table created in a file-per-table tablespace or general tablespace, table data and associated indexes are stored in a .ibd file in the database directory. When an InnoDB table is created in the system tablespace, table data and ...The ...
https://dev.mysql.com/doc/mysql-errors/8.4/en/server-error-reference.html
Error number: 1005; Symbol: ER_CANT_CREATE_TABLE; SQLSTATE: HY000 Message: Can't create table '%s' (errno: %d - %s) InnoDB reports this error when a table cannot be created. If the error message refers to error 150, table creation failed because a ...Error number: 1004; Symbol: ER_CANT_CREATE_FILE; SQLSTATE: HY000 Message: Can't create file '%s' (errno: %d - %s) Occurs for failure to create or copy a file needed for some ...
https://dev.mysql.com/doc/refman/8.4/en/federated-create-server.html
If you are creating a number of FEDERATED tables on the same server, or if you want to simplify the process of creating FEDERATED tables, you can use the CREATE SERVER statement to define the server connection parameters, just as you would with the ...If you specify only the connection name without a table name, the table name of the local table is used ...
https://dev.mysql.com/doc/refman/8.4/en/create-procedure.html
Consider the following procedure, which displays a count of the number of MySQL accounts listed in the mysql.user system table: CREATE DEFINER = 'admin'@'localhost' PROCEDURE account_count() BEGIN SELECT 'Number of accounts:', COUNT(*) FROM ...To ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-select.html
You can create one table from another by adding a SELECT statement at the end of the CREATE TABLE statement: CREATE TABLE new_tbl [AS] SELECT * FROM orig_tbl; MySQL creates new columns for all elements in the SELECT. For example: mysql> CREATE ...
https://dev.mysql.com/doc/refman/8.4/en/create-index.html
CREATE INDEX is mapped to an ALTER TABLE statement to create indexes. CREATE INDEX cannot be used to create a PRIMARY KEY; use ALTER TABLE instead. When the innodb_stats_persistent setting is enabled, run the ANALYZE TABLE statement for an InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-create-table-external.html
There are different reasons for creating InnoDB tables externally; that is, creating tables outside of the data directory. InnoDB supports the following methods for creating tables externally: Using the DATA DIRECTORY Clause Using CREATE TABLE ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-create-temp-table.html
As of MySQL 9.3.0, you can create temporary tables that are stored in the MySQL HeatWave Cluster. Once created, you can use a MySQL HeatWave temporary table as an independent entity. After the MySQL HeatWave temporary table is created, you can ...A ...To learn how to download the sample database, see AirportDB Analytics ...
https://dev.mysql.com/doc/refman/8.4/en/glossary.html
The corresponding row in the parent table must exist before the row can be created in the child table. The values in the child table can prevent delete or update operations on the parent table, or can cause automatic deletion or updates in the child ...If related data is being updated across multiple tables, queries see either all old values or all new values, not a mix of old and new ...