Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-metrics-table.html
Because no DML operations have been performed, the counter values are zero or NULL. row *************************** NAME: dml_inserts SUBSYSTEM: dml COUNT: 0 MAX_COUNT: 0 MIN_COUNT: NULL AVG_COUNT: 0 COUNT_RESET: 0 MAX_COUNT_RESET: 0 ... The ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/trouble.logging.html
Because the backup_history table used to be in the CSV format, which cannot register NULL values directly, if binary logging is not enabled, a value of -1 is entered into the column; the same applies to other columns for the logging of NULL values.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-schema.html
Note When performing schema changes on NDB tables, applications should wait until the ALTER TABLE statement has returned in the MySQL client connection that issued the statement before attempting to use the updated definition of the table.
https://dev.mysql.com/doc/refman/8.4/en/sql-mode.html
To clear the SQL mode explicitly, set it to an empty string using --sql-mode="" on the command line, or sql-mode="" in an option file. ANSI_QUOTES Treat " as an identifier quote character (like the ` quote character) and not as a string quote ...
https://dev.mysql.com/doc/refman/8.4/en/enum.html
Creating and Using ENUM Columns Index Values for Enumeration Literals Handling of Enumeration Literals Empty or NULL Enumeration Values Enumeration Sorting Enumeration Limitations Creating and Using ENUM Columns An enumeration value must be a quoted ... An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation ...
https://dev.mysql.com/doc/refman/8.4/en/window-functions-frames.html
For RANGE, the bound is the rows with values equal to the current row value minus expr; if the current row value is NULL, the bound is the peers of the row. For RANGE, the bound is the rows with values equal to the current row value plus expr; if ...
https://dev.mysql.com/doc/refman/8.4/en/information-functions.html
CHARSET(str) Returns the character set of the string argument, or NULL if the argument is NULL. The result value is 0, or NULL for inappropriate arguments such as a NULL or negative repeat count. mysql> SELECT CHARSET('abc'); -> 'utf8mb3' mysql> ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-undo-tablespaces.html
Attempting to drop an undo tablespace that is not empty returns an error. The purge system empties rollback segments by freeing undo logs that are no longer in use. Undo tablespaces contain undo logs, which are collections of records containing ...
https://dev.mysql.com/doc/x-devapi-userguide/en/working-with-sql-result-sets.html
The data set can be empty if, for example, fetchOne() returns NULL or fetchAll() returns an empty list. When you execute an SQL operation on a Session using the sql() method, an SqlResult is returned. Iterating over an SqlResult is identical to ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-utilities-table-export.html
If you are exporting the data to the local filesystem, outputUrl is a string specifying the path to the exported data file, and the file name itself, with an appropriate extension. Options where: "string" A valid SQL condition expression used to ...