Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-ft-index-cache-table.html
The INNODB_FT_INDEX_CACHE table provides token information about newly inserted rows in a FULLTEXT index. Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-consistent-read.html
This exception causes the following anomaly: If you update some rows in a table, a SELECT sees the latest version of the updated rows, but it might also see older versions of any rows. If other sessions simultaneously update the same table, the ...
https://dev.mysql.com/doc/refman/8.4/en/json-table-functions.html
This is equivalent to specifying a column as AUTO_INCREMENT in a CREATE TABLE statement, and can be used to distinguish parent rows with the same value for multiple rows generated by a NESTED [PATH] clause. JSON_TABLE(expr, path COLUMNS ... This ...
https://dev.mysql.com/doc/refman/8.4/en/show-columns.html
The data types may differ from what you expect them to be based on a CREATE TABLE statement because MySQL sometimes changes data types when you create or alter a table. The SHOW CREATE TABLE, SHOW TABLE STATUS, and SHOW INDEX statements also provide ... SHOW [EXTENDED] [FULL] {COLUMNS | FIELDS} {FROM | IN} tbl_name [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW COLUMNS displays information about the columns in a given ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-functions-for-new-primary.html
You can identify the current primary using the MEMBER_ROLE column in the Performance Schema replication_group_members table. In MySQL 8.4, it also waits for the completion of any ongoing DDL statements such as ALTER TABLE. The following function ...
MySQL 8.4 Reference Manual :: A.11 MySQL 8.4 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
https://dev.mysql.com/doc/refman/8.4/en/faqs-cjk.html
Why do I get Incorrect string value error messages? To see the problem, create a table with one Unicode (ucs2) column and one Chinese (gb2312) column. mysql> CREATE TABLE ch (ucs2 CHAR(3) CHARACTER SET ucs2, gb2312 CHAR(3) CHARACTER SET gb2312); In ...Does MySQL permit CJK characters to be used in database and table names? ... This set of Frequently Asked Questions derives from the experience of MySQL's Support and ...
https://dev.mysql.com/doc/refman/8.4/en/getting-information.html
You can obtain the CREATE TABLE statement necessary to create an existing table using the SHOW CREATE TABLE statement. What if you forget the name of a database or table, or what the structure of a given table is (for example, what its columns are ...You have previously seen SHOW DATABASES, which lists the databases managed by the ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-hash.html
To partition a table using HASH partitioning, it is necessary to append to the CREATE TABLE statement a PARTITION BY HASH (expr) clause, where expr is an expression that returns an integer. In addition, you most likely want to follow this with ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-key-column-usage-table.html
This table provides no information about functional key parts because they are expressions and the table provides information only about columns. The KEY_COLUMN_USAGE table has these columns: CONSTRAINT_CATALOG The name of the catalog to which the ...CONSTRAINT_SCHEMA The name of the schema (database) to which the constraint ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-importing-data-bulk-ingesting.html
For example, the following query creates a new database, airportdb, and selects the database for further actions: CREATE DATABASE airportdb; USE airportdb; Use an existing empty table or create a new table. <Table-name>: Specify an already existing ...See Creating an IAM Role to Access an Amazon S3 Bucket, Creating a DB System, and Editing a DB ... Importing Data Using the Bulk Ingest Feature 7.2.2.2 Importing Data Using the Bulk Ingest Feature ...