PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/numeric-type-attributes.html
When you insert a value of NULL into an indexed AUTO_INCREMENT column, the column is set to the next sequence value. (AUTO_INCREMENT sequences begin with 1.) Storing 0 into an AUTO_INCREMENT column has the same effect as storing NULL, unless the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-timing.html
The rows that do not contain NULL indicate which timers you can use in setup_timers. The timers in setup_timers that you can use are those that do not have NULL in the other columns. If the values associated with a given timer name are NULL, that ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-system-variables.html
group_replication_force_members Command-Line Format --group-replication-force-members=value Introduced 5.7.17 System Variable group_replication_force_members Scope Global Dynamic Yes Type String A list of peer addresses as a comma separated list ...
https://dev.mysql.com/doc/refman/5.7/en/alter-user.html
In one case only, the account may be specified with the USER() function: ALTER USER USER() IDENTIFIED BY 'auth_string'; This syntax enables changing your own password without naming your account literally. The plugin name can be a quoted string ...
https://dev.mysql.com/doc/refman/5.7/en/known-issues.html
When inserting a big integer value (between 263 and 264−1) into a decimal or string column, it is inserted as a negative value because the number is evaluated in signed integer context. SELECT statements that insert zero or NULL values into an ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-differing-tables.html
A column's default value is determined by a number of factors, including its type, whether it is defined with a DEFAULT option, whether it is declared as NULL, and the server SQL mode in effect at the time of its creation; for more information, see ... Source and target tables for replication do not have to be ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlslap.html
Invoke mysqlslap like this: mysqlslap [options] Some options such as --create or --query enable you to specify a string containing an SQL statement or a file containing statements. --create=value Command-Line Format --create=value Type String The ...
https://dev.mysql.com/doc/refman/5.7/en/create-procedure.html
Its initial value is NULL within the procedure, and its value is visible to the caller when the procedure returns. For example, if a function specifies an ENUM or SET value in the RETURNS clause, but the RETURN statement returns an integer, the ...
https://dev.mysql.com/doc/refman/5.7/en/engine-condition-pushdown-optimization.html
column IS [NOT] NULL column IN (value_list) Each item in the value_list must be a constant, literal value. A string value to be compared with a column must use the same collation as the column. This optimization improves the efficiency of direct ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-filter-definitions.html
Arguments can refer to predefined variables, event fields, or string or numeric constants. The following list describes the permitted predefined functions for function items: audit_log_exclude_accounts_is_null() Checks whether the ...For information ...