Search Results
https://dev.mysql.com/doc/refman/8.4/en/charset.html
MySQL includes character set support that enables you to store data using a variety of character sets and perform comparisons according to a variety of collations. The default MySQL server character set and collation are utf8mb4 and ...To maximize ...
https://dev.mysql.com/doc/refman/8.4/en/commit.html
Important Many APIs used for writing MySQL client applications (such as JDBC) provide their own methods for starting transactions that can (and sometimes should) be used instead of sending a START TRANSACTION statement from the client. MySQL enables ...SET autocommit disables or enables the default autocommit mode for the current ...
https://dev.mysql.com/doc/refman/8.4/en/constraint-primary-key.html
If you are using a transactional storage engine such as InnoDB, MySQL automatically rolls back the statement. If you are using a nontransactional storage engine, MySQL stops processing the statement at the row for which the error occurred and leaves ... Normally, errors occur for data-change statements (such as INSERT or UPDATE) that would violate primary-key, unique-key, or foreign-key ...
https://dev.mysql.com/doc/refman/8.4/en/create-server.html
The CREATE SERVER statement creates a new row in the servers table in the mysql database. The CREATE SERVER statement creates an entry in the mysql.servers table that can later be used with the CREATE TABLE statement when creating a FEDERATED table.
https://dev.mysql.com/doc/refman/8.4/en/creating-spatial-indexes.html
For InnoDB and MyISAM tables, MySQL can create spatial indexes using syntax similar to that for creating regular indexes, but using the SPATIAL keyword. For storage engines that support nonspatial indexing of spatial columns, the engine creates a ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-file-removal.html
In previous MySQL releases, dictionary data was partially stored in metadata files. The Information Schema TABLES table's VERSION column reports a hardcoded value of 10, which is the last .frm file version used in MySQL 5.7. InnoDB stopped using ...
https://dev.mysql.com/doc/refman/8.4/en/descending-indexes.html
MySQL supports descending indexes: DESC in an index definition is no longer ignored but causes storage of key values in descending order. Previously, indexes could be scanned in reverse order but at a performance penalty. A descending index can be ...
https://dev.mysql.com/doc/refman/8.4/en/drop-function-loadable.html
It requires the DELETE privilege for the mysql system schema because it removes the row from the mysql.func system table that registers the function. DROP FUNCTION also removes the function from the Performance Schema user_defined_functions table ...
https://dev.mysql.com/doc/refman/8.4/en/drop-view.html
Note In MySQL 8.3 and earlier, DROP VIEW returns an error if any views named in the argument list do not exist, but also drops all views in the list that do exist. Due to the change in behavior in MySQL 8.4, a partially completed DROP VIEW operation ...If any views named in the argument list do not exist, the statement fails with an error indicating by name which nonexisting views it was unable to drop, and no changes are ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-priority-based-filtering.html
In the MySQL error log, system messages are labeled as “System”. In addition, each error code specified must actually be used by MySQL. Attempts to specify a code not within a permitted range or within a permitted range but not used by MySQL ...