Search Results
https://dev.mysql.com/doc/workbench/en/wb-preferences-sql-editor.html
Figure 3.8 Preferences: SQL Editor: Object Editors Online DDL Default algorithm for ALTER table: [ Default ] Sets the default algorithm when performing ALTER TABLE operations in MySQL Workbench. The setting can also be adjusted for each ALTER TABLE ...For this reason, this facility can be switched off for models containing large numbers of schemas and ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-search-ngram.html
Creating a FULLTEXT Index that Uses the ngram Parser To create a FULLTEXT index that uses the ngram parser, specify WITH PARSER ngram with CREATE TABLE, ALTER TABLE, or CREATE INDEX. The following example demonstrates creating a table with an ngram ... The built-in MySQL full-text parser uses the white space between words as a delimiter to determine where words begin and end, which is a limitation when working with ideographic languages that do not use word ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor.html
You can add or modify the columns or indexes of a table, change the engine, add foreign keys, or alter the table name. To access the MySQL Table Editor, right-click a table name in the Navigator area of the sidebar with the Schemas secondary tab ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-apptips-microsoft-access.html
If you want to have MEMO columns instead, change BLOB columns to TEXT with ALTER TABLE. Include a TIMESTAMP column in all tables that you want to be able to update. Include a primary key in each MySQL table you want to use with Access. If you are ...
https://dev.mysql.com/doc/refman/8.4/en/constraint-foreign-key.html
MySQL supports ON UPDATE and ON DELETE foreign key references in CREATE TABLE and ALTER TABLE statements. Foreign keys let you cross-reference related data across tables, and foreign key constraints help keep this spread-out data consistent. MySQL ...The available referential actions are RESTRICT, CASCADE, SET NULL, and NO ACTION (the ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-file-removal.html
ddl_log.log file: The file contained records of metadata operations generated by data definition statements such as DROP TABLE and ALTER TABLE. Unless otherwise noted, data previously stored in metadata files is now stored in data dictionary tables.
https://dev.mysql.com/doc/refman/8.4/en/innodb-read-only-instance.html
The same restriction applies to any operation that modifies data dictionary tables, such as ANALYZE TABLE and ALTER TABLE tbl_name ENGINE=engine_name. You can query InnoDB tables where the MySQL data directory is on read-only media by enabling the ...How to Enable To prepare an instance for read-only operation, make sure all the necessary information is flushed to the data files before storing it on the read-only ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-table-formats.html
When you use CREATE TABLE or ALTER TABLE for a table that has no BLOB or TEXT columns, you can force the table format to FIXED or DYNAMIC with the ROW_FORMAT table option. The third, compressed format, can be created only with the myisampack utility ...Two of them, fixed and dynamic format, are chosen automatically depending on the type of columns you are ...
https://dev.mysql.com/doc/refman/8.4/en/show-warnings.html
Warnings are generated for DML statements such as INSERT, UPDATE, and LOAD DATA as well as DDL statements such as CREATE TABLE and ALTER TABLE. The ALTER TABLE statement produces three warning messages (strict SQL mode is disabled for the example to ...mysql> CREATE TABLE t1 (a TINYINT NOT NULL, b CHAR(4)); Query OK, 0 rows affected (0.05 sec) mysql> INSERT INTO t1 VALUES(10,'mysql'), (NULL,'test'), (300,'xyz'); Query OK, 3 rows affected, 3 warnings (0.00 sec) Records: 3 Duplicates: 0 Warnings: 3 mysql> SHOW WARNINGS\G ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-other.html
Operations involving ALTER TABLE such as loading, unloading, or recovering data when MySQL Server is running in SUPER_READ_ONLY mode. The function definition must not contain CREATE, INSERT, ALTER, UPDATE, or DELETE statements. For a list of ...