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/innodb-auto-increment-handling.html
An example follows, where c1 is an AUTO_INCREMENT column of table t1: INSERT INTO t1 (c1,c2) VALUES (1,'a'), (NULL,'b'), (5,'c'), (NULL,'d'); Another type of “mixed-mode insert” is INSERT ... To make this clear, consider an example that uses ...
https://dev.mysql.com/doc/refman/5.7/en/type-conversion.html
For example, MySQL automatically converts strings to numbers as necessary, and vice versa. mysql> SELECT 1+'1'; -> 2 mysql> SELECT CONCAT(2,' test'); -> '2 test' It is also possible to convert a number to a string explicitly using the CAST() ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-pruning.html
Important Invalid DATE and DATETIME values referenced in the WHERE condition of a statement against a partitioned table are treated as NULL. The core concept behind partition pruning is relatively simple, and can be described as “Do not scan ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statement-performance-analyzer.html
If in_table is NULL and no snapshot exists, a new snapshot is created. Creates a report of the statements running on the server. The views are calculated based on the overall and/or delta activity. This procedure disables binary logging during its ...
https://dev.mysql.com/doc/refman/5.7/en/locking-service.html
A namespace or lock name specified as NULL, the empty string, or a string longer than 64 characters results in an ER_LOCKING_SERVICE_WRONG_NAME error. lock_names: An array of null-terminated strings that provides the names of the locks to acquire.
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-exchange.html
Table nt contains no foreign key references, and no other table has any foreign keys that refer to nt. There are no rows in nt that lie outside the boundaries of the partition definition for p. This condition does not apply if the WITHOUT VALIDATION ...
https://dev.mysql.com/doc/refman/5.7/en/precision-math-examples.html
This section provides some examples that show precision math query results in MySQL. These examples demonstrate the principles described in Section 12.21.3, “Expression Handling”, and Section 12.21.4, “Rounding Behavior”. Consider the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-import.html
Higher values reduce status printing exponentially up to some pre-defined limit ADDED: NDB 7.6.2 --ndb-connectstring=connection_string, -c connection_string Set connect string for connecting to ndb_mgmd. Overrides entries in NDB_CONNECTSTRING and ...
https://dev.mysql.com/doc/refman/5.7/en/grant-tables.html
The value is non-NULL only for accounts that use MySQL built-in authentication methods (accounts that use an authentication plugin of mysql_native_password or sha256_password). The value is NULL for other accounts, such as those authenticated using ... The mysql system database includes several grant tables that contain information about user accounts and the privileges held by ...
https://dev.mysql.com/doc/refman/5.7/en/gis-wkb-functions.html
LineFromWKB(wkb [, srid]), LineStringFromWKB(wkb [, srid]) ST_LineFromWKB(), ST_LineStringFromWKB(), LineFromWKB(), and LineStringFromWKB() are synonyms. LineFromWKB() and LineStringFromWKB() are deprecated; expect them to be removed in a future ...