Search Results
https://dev.mysql.com/doc/refman/9.7/en/invisible-indexes.html
For example, an index continues to be updated per changes to table rows, and a unique index prevents insertion of duplicates into a column, regardless of whether the index is visible or invisible. If the flag is on, invisible indexes remain ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-tips.html
The mysql client parser does not take the ANSI_QUOTES SQL mode into account. This section provides information about techniques for more effective use of mysql and about mysql operational behavior. Input-Line Editing Disabling Interactive History ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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.25.3, “Expression Handling”.) Values for DECIMAL columns are stored using a binary ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/en/replication-options-replica.html
When the replication SQL thread replicates a LOAD DATA statement, it extracts the file to be loaded from the relay log into temporary files, and then loads these into the table. This section explains the server options and system variables that ...
https://dev.mysql.com/doc/refman/9.7/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, ...