Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning-overview.html
There are no plans at this time to introduce vertical partitioning into MySQL. Partition selection is also supported for the data modification statements DELETE, INSERT, REPLACE, UPDATE, and LOAD DATA, LOAD XML. This section provides a conceptual ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-digests.html
Once that amount of space is used during digest computation, truncation occurs: no further tokens from a parsed statement are collected or figure into its digest value. This gives the developer insight into which parts of the application need ...
https://dev.mysql.com/doc/refman/8.4/en/pluggable-storage.html
MySQL Server uses a pluggable storage engine architecture that enables storage engines to be loaded into and unloaded from a running MySQL server. Plugging in a Storage Engine Before a storage engine can be used, the storage engine plugin shared ...
https://dev.mysql.com/doc/refman/8.4/en/precision-math-decimal-characteristics.html
If you insert +0003.1 into a DECIMAL(5,1) column, it is stored as 3.1. (There is also a limit on how long the text of DECIMAL literals can be; see Section 14.24.3, “Expression Handling”.) Values for DECIMAL columns are stored using a binary ...
https://dev.mysql.com/doc/refman/8.4/en/privilege-changes.html
If the mysqld server is started without the --skip-grant-tables option, it reads all grant table contents into memory during its startup sequence. If you modify the grant tables indirectly using an account-management statement, the server notices ...The in-memory tables become effective for access control at that ...
https://dev.mysql.com/doc/refman/8.4/en/rename-table.html
You must have ALTER and DROP privileges for the original table, and CREATE and INSERT privileges for the new table. If a table has triggers, attempts to rename the table into a different database fail with a Trigger in wrong schema ... RENAME TABLE ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-aggregate-functions.html
As with other aggregate functions, GROUP BY may be used to group arguments into subsets. MySQL supports aggregate functions that perform a calculation on a set of values. For general information about these functions, see Section 14.19.1, ...
https://dev.mysql.com/doc/refman/8.4/en/two-digit-years.html
For YEAR, the rules are the same, with this exception: A numeric 00 inserted into YEAR results in 0000 rather than 2000. Such values must be interpreted into 4-digit form because MySQL stores years internally using 4 digits. Date values with ...
https://dev.mysql.com/doc/refman/8.4/en/update.html
Note Unlike the case when using PARTITION with an INSERT or REPLACE statement, an otherwise valid UPDATE ... UPDATE is a DML statement that modifies rows in a table. An UPDATE statement can start with a WITH clause to define common table ...
https://dev.mysql.com/doc/refman/8.4/en/using-mysqldump.html
This output consists of CREATE statements to create dumped objects (databases, tables, stored routines, and so forth), and INSERT statements to load data into tables. Dumps can be easily imported into a MySQL Server instance or a MySQL HeatWave DB ... Tip Consider using the MySQL Shell dump utilities, which provide parallel dumping with multiple threads, file compression, and progress information display, as well as cloud features such as Oracle Cloud Infrastructure Object Storage streaming, and MySQL HeatWave compatibility checks and ...