Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-table-select.html
SELECT, the destination table does not preserve information about whether columns in the selected-from table are generated columns. The SELECT part of the statement cannot assign values to generated columns in the destination table. You can create ...The ENGINE option is part of the CREATE TABLE statement, and should not be used following the SELECT; this would result in a syntax ...
https://dev.mysql.com/doc/internals/en/com-query-response.html
In case the query could generate the column-definition, but generating the rows afterwards failed, a ERR_Packet may be sent instead of the last EOF_Packet. It is made up of two parts: the column definitions the rows which consist of a sequence of ...
https://dev.mysql.com/doc/refman/8.4/en/blob.html
If strict SQL mode is not enabled and you assign a value to a BLOB or TEXT column that exceeds the column's maximum length, the value is truncated to fit and a warning is generated. Truncation of excess trailing spaces from values to be inserted ...
https://dev.mysql.com/doc/refman/8.4/en/char.html
If strict SQL mode is not enabled and you assign a value to a CHAR or VARCHAR column that exceeds the column's maximum length, the value is truncated to fit and a warning is generated. For VARCHAR columns, trailing spaces in excess of the column ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-table-info.html
Auto increment key, Last value The key number associated the table's AUTO_INCREMENT column, and the most recently generated value for this column. “Record” and “row” are synonymous, as are “field” and “column.” The initial part of ...
https://dev.mysql.com/doc/refman/8.4/en/engine-condition-pushdown-optimization.html
This means that there is no single specific row from which column values can be fetched from when generating the scan filter. This optimization improves the efficiency of direct comparisons between a nonindexed column and a constant. column IS ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-introduction.html
Information about generated invisible primary keys is visible by default in all INFORMATION_SCHEMA tables describing table columns, keys, or both, such as the COLUMNS and STATISTICS tables. INFORMATION_SCHEMA provides access to database metadata, ...Other terms that are sometimes used for this information are data dictionary and system ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-statistics-table.html
The following statements are equivalent: SELECT * FROM INFORMATION_SCHEMA.STATISTICS WHERE table_name = 'tbl_name' AND table_schema = 'db_name' SHOW INDEX FROM tbl_name FROM db_name Information about generated invisible primary key columns is ...If ...The information_schema_stats_expiry system variable defines the period of time before cached table statistics ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-key.html
KEY takes only a list of zero or more column names. Any columns used as the partitioning key must comprise part or all of the table's primary key, if the table has one. Where no column name is specified as the partitioning key, the table's primary ... Partitioning by key is similar to partitioning by hash, except that where hash partitioning employs a user-defined expression, the hashing function for key partitioning is supplied by the MySQL ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-errors.html
This fixes a bug in Access that when you export data to MySQL, the table and column names aren't specified. This fixes some cases where columns are marked as #DELETED# in Access. If you are using Connector/ODBC to link to a table that has a BIGINT ... The following section details some common errors and their suggested fix or alternative ...