Search Results
https://dev.mysql.com/doc/refman/8.4/en/numeric-type-attributes.html
(AUTO_INCREMENT sequences begin with 1.) Storing 0 into an AUTO_INCREMENT column has the same effect as storing NULL, unless the NO_AUTO_VALUE_ON_ZERO SQL mode is enabled. MySQL supports an extension for optionally specifying the display width of ...
https://dev.mysql.com/doc/refman/8.4/en/numeric-types.html
MySQL also treats REAL as a synonym for DOUBLE PRECISION (a nonstandard variation), unless the REAL_AS_FLOAT SQL mode is enabled. These types include the exact numeric data types (INTEGER, SMALLINT, DECIMAL, and NUMERIC), as well as the approximate ...
https://dev.mysql.com/doc/refman/8.4/en/password-logging.html
Use a restricted access mode to protect database backups that include log tables or log files containing passwords. Passwords can be written as plain text in SQL statements such as CREATE USER, GRANT and SET PASSWORD. If such statements are logged ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-data-locks-table.html
row *************************** ENGINE: INNODB ENGINE_LOCK_ID: 139664434886512:1059:139664350547912 ENGINE_TRANSACTION_ID: 2569 THREAD_ID: 46 EVENT_ID: 12 OBJECT_SCHEMA: test OBJECT_NAME: t1 PARTITION_NAME: NULL SUBPARTITION_NAME: NULL INDEX_NAME: ...For information about which lock requests are blocked by which held locks, see Section 29.12.13.2, “The data_lock_waits ...
https://dev.mysql.com/doc/refman/8.4/en/precision-math-rounding.html
Such truncation is not an error, even in strict SQL mode (see Section 14.24.3, “Expression Handling”). This section discusses precision math rounding for the ROUND() function and for inserts into columns with exact-value types (DECIMAL and ...
https://dev.mysql.com/doc/refman/8.4/en/program-options.html
The following command runs mysql in “no column names” mode: mysql --column-names --skip-column-names MySQL programs determine which options are given first by examining environment variables, then by processing option files, and then by checking ... There are several ways to specify options for MySQL programs: List the options on the command line following the program ...
https://dev.mysql.com/doc/refman/8.4/en/programs-overview.html
MySQL client programs that connect to the MySQL server: mysql The command-line tool for interactively entering SQL statements or executing them from a file in batch mode. Later sections provide a more detailed description of each one, with the ...
https://dev.mysql.com/doc/refman/8.4/en/replica-logs-status.html
Use a restricted access mode to protect database backups that include this table. A replica server creates two replication metadata repositories, the connection metadata repository and the applier metadata repository. If binary log file position ...
https://dev.mysql.com/doc/refman/8.4/en/replication-binlog-encryption-scope.html
When binary log encryption is active on the server, temporary files used to hold the binary log cache are encrypted using AES-CTR (AES Counter mode) for stream encryption. Note If you use LOAD DATA when binlog_format=STATEMENT is set, which is not ...Existing binary log files and relay log files that were present on the server when you started encryption are not ...
https://dev.mysql.com/doc/refman/8.4/en/replication-functions-synchronization.html
(When the server is running in strict SQL mode, a negative timeout value is immediately rejected with ER_WRONG_ARGUMENTS; otherwise the function returns NULL, and raises a warning.) The optional channel value enables you to name which replication ...