Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-ft-config-table.html
use_stopword: Indicates whether a stopword table is used, which is defined when the FULLTEXT index is created. The INNODB_FT_CONFIG table provides metadata about the FULLTEXT index and associated processing for an InnoDB table. Before querying it, ...The values for this column might change, depending on the needs for performance tuning and debugging for InnoDB full-text ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-rag-table.html
Note In versions older than MySQL 9.2.1, to alter an existing table or create a new table, MySQL requires you to set the sql-require-primary-key system variable to 0. If the specified output table doesn't exist, then a new table is created. The ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-exclude-table-columns.html
To exclude a column, specify the NOT SECONDARY column attribute in an ALTER TABLE or CREATE TABLE statement, as shown below. mysql> ALTER TABLE tbl_name MODIFY column_name datatype NOT SECONDARY; mysql> CREATE TABLE tbl_name ( column_1 datatype, ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-metrics-table.html
Create a simple InnoDB table: mysql> USE test; Database changed mysql> CREATE TABLE t1 (c1 INT) ENGINE=INNODB; Query OK, 0 rows affected (0.02 sec) Enable the dml_inserts counter. The INNODB_METRICS table provides information about InnoDB ...SET ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-transactions-current-table.html
The table stores one row per thread showing the current status of the thread's most recent monitored transaction event, so there is no system variable for configuring the table size. Other tables that contain transaction event rows are logically ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-processlist-table.html
For a comparison of this table with other sources, see Sources of Process Information. Note If the performance_schema_show_processlist system variable is enabled, the processlist table also serves as the basis for an alternative implementation ...
https://dev.mysql.com/doc/workbench/en/wb-basic-add-table.html
Create a table on the canvas by clicking anywhere on the EER Diagram grid. Pressing Tab or Enter while the cursor is in the table name field selects the Columns tab of the table editor and creates a default column named idinvoice. The table tool is ... The tools in the vertical toolbar on the left of the EER Diagram tab are used for designing an EER ...
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/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/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 ...