Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-index.html
This guideline is especially important for InnoDB tables, where the primary key determines the physical layout of rows in the data file. CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-gipks.html
When creating or importing backups of installations where GIPKs are in use, it is possible to exclude generated invisible primary key columns and values. MySQL 8.4 supports generated invisible primary keys for any InnoDB table that is created ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-like.html
LIKE to create an empty table based on the definition of another table, including any column attributes and indexes defined in the original table: CREATE TABLE new_tbl LIKE orig_tbl; The copy is created using the same version of the table storage ...
https://dev.mysql.com/doc/refman/8.4/en/creating-database.html
For example: $> mysql -h host -u user -p menagerie Enter password: ******** Important menagerie in the command just shown is not your password. If the administrator creates your database for you when setting up your permissions, you can begin using ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-usage-differences.html
Note Enabling innodb_read_only also has important implications for non-data dictionary tables in the mysql system database. Use of a data dictionary-enabled MySQL server entails some operational differences compared to a server that does not have a ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary.html
Important A data dictionary-enabled server entails some general operational differences compared to a server that does not have a data dictionary; see Section 16.7, “Data Dictionary Usage Differences”. MySQL Server incorporates a transactional ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-component-functions.html
Important Dictionaries and their terms are persisted to a table in the mysql schema. mask_canada_sin(str [, mask_char]) Masks a Canada Social Insurance Number (SIN) and returns the number with all meaningful digits replaced by 'X' characters. Nine ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-plugin-functions.html
The MySQL Enterprise Data Masking and De-Identification plugin library includes several functions, which may be grouped into these categories: Data Masking Plugin Functions Random Data Generation Plugin Functions Random Data Dictionary-Based Plugin ...
https://dev.mysql.com/doc/refman/8.4/en/data-size.html
If speed is more important than disk space and the maintenance costs of keeping multiple copies of data, for example in a business intelligence scenario where you analyze all the data from large tables, you can relax the normalization rules, ...
https://dev.mysql.com/doc/refman/8.4/en/docker-mysql-more-topics.html
A MySQL Docker installation is different from a common, non-Docker installation in the following aspects: Only a limited number of binaries are included. Warning Any software updates or installations users perform to the Docker container (including ...