Search Results
https://dev.mysql.com/doc/refman/8.4/en/insert.html
If you do not know the order of the columns in the table, use DESCRIBE tbl_name to find out. INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] ...
https://dev.mysql.com/doc/refman/8.4/en/json-functions.html
Functions that return JSON values always perform normalization of these values (see Normalization, Merging, and Autowrapping of JSON Values), and thus orders them. The functions described in this section perform operations on JSON values. For ...
https://dev.mysql.com/doc/refman/8.4/en/key-space.html
This is for the worst case when all keys are inserted in sorted order and the table doesn't have any compressed keys. You can roughly calculate the size for the index file as (key_length+4)/0.67, summed over all keys. If the first index part is a ...
https://dev.mysql.com/doc/refman/8.4/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Some keywords which are otherwise ...
https://dev.mysql.com/doc/refman/8.4/en/kill.html
In most cases, it might take some time for the thread to die because the kill flag is checked only at specific intervals: During SELECT operations, for ORDER BY and GROUP BY loops, the flag is checked after reading a block of rows. KILL [CONNECTION ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-apt-repo.html
This section provides guidance on installing MySQL using the MySQL APT repository. First, add the MySQL APT repository to your system's software repository list. Follow these steps: Go to the download page for the MySQL APT repository at ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-debian.html
Oracle provides Debian packages for installing MySQL on Debian or Debian-like Linux systems. The packages are available through two different channels: The MySQL APT Repository. This is the preferred method for installing MySQL on Debian-like ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-native.html
Note The apt-get command installs a number of packages, including the MySQL server, in order to provide the typical tools and application environment. Many Linux distributions include a version of the MySQL server, client tools, and development ...
https://dev.mysql.com/doc/refman/8.4/en/load-index.html
When preloading indexes for multiple partitions, the partitions need not be contiguous, and you need not list their names in any particular order. tbl_index_list: tbl_name [PARTITION (partition_list)] [{INDEX|KEY} (index_name[, index_name] ...)] ...
https://dev.mysql.com/doc/refman/8.4/en/monitor-alter-table-performance-schema.html
In order of occurrence, ALTER TABLE stage events include: stage/innodb/alter table (read PK and internal sort): This stage is active when ALTER TABLE is in the reading-primary-key phase. You can monitor ALTER TABLE progress for InnoDB tables using ...