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/proxy-users.html
Suppose that my_auth_plugin returns a user name of employee to the server, based on the content of 'my_auth_string' and perhaps by consulting some external authentication system. If present, the string provides information that helps the plugin ...
https://dev.mysql.com/doc/refman/5.7/en/host-cache.html
Initially, the host name is set to NULL and the flag is false. For permanent failures, the host name remains NULL and the validation flag is set to true. The MySQL server maintains an in-memory host cache that contains information about clients: IP ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-syntax.html
Attempting to create an index on an NDB table column whose width is greater than 3072 bytes is rejected with ER_TOO_LONG_KEY: Specified key was too long; max key length is 3072 bytes. Attempting to create an index on an NDB table column whose width ... Some SQL statements relating to certain MySQL features produce errors when used with NDB tables, as described in the following list: Temporary ...
https://dev.mysql.com/doc/refman/5.7/en/storage-engines.html
row *************************** Engine: BLACKHOLE Support: YES Comment: /dev/null storage engine (anything you write to it disappears) Transactions: NO XA: NO Savepoints: NO *************************** 5. Blackhole: The Blackhole storage engine ...
https://dev.mysql.com/doc/refman/5.7/en/thread-information.html
row *************************** Id: 1 User: event_scheduler Host: localhost db: NULL Command: Daemon Time: 2756681 State: Waiting on empty queue Info: NULL *************************** 2. To ascertain what your MySQL server is doing, it can be ...
https://dev.mysql.com/doc/refman/5.7/en/where-optimization.html
This is also done for any NOT NULL expression when used with only one table. A table that is used with a WHERE clause on a PRIMARY KEY or a UNIQUE index, where all index parts are compared to constant expressions and are defined as NOT NULL. This ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking-usage.html
General-Purpose Masking Functions mask_inner() and mask_outer() are general-purpose functions that mask parts of arbitrary strings based on position within the string: mask_inner() masks the interior of its string argument, leaving the ends unmasked. Converting the value to a binary string ensures that the function sees an argument of length ... Before using MySQL Enterprise Data Masking and De-Identification, install it according to the instructions provided at ...
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 ...