PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
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/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/spatial-geojson-functions.html
mysql> SELECT ST_AsGeoJSON(ST_GeomFromText('POINT(11.11111 12.22222)'),2); +-------------------------------------------------------------+ | ST_AsGeoJSON(ST_GeomFromText('POINT(11.11111 12.22222)'),2) | ... This section describes functions for ...