PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/string-functions.html
BIN(N) Returns a string representation of the binary value of N, where N is a longlong (BIGINT) number. For a numeric argument N, HEX() returns a hexadecimal string representation of the value of N treated as a longlong (BIGINT) number. OCT(N) ...
https://dev.mysql.com/doc/refman/9.7/en/known-issues.html
Numeric calculations are done with BIGINT or DOUBLE (both are normally 64 bits long). The general rule is that bit functions are performed with BIGINT precision, IF() and ELT() with BIGINT or DOUBLE precision, and the rest with DOUBLE precision.
https://dev.mysql.com/doc/refman/9.7/en/type-conversion.html
If the maximum length of the expression does not fit in an INT, BIGINT is used instead. This means that you can force a BIGINT rather than INT by use of a sufficiently long expression: CREATE TABLE t SELECT 000000000000000000000; . When an operator ...
https://dev.mysql.com/doc/refman/9.7/en/replication-gtids-concepts.html
A global transaction identifier (GTID) is a unique identifier created and associated with each transaction committed on the server of origin (the source). This identifier is unique not only to the server on which it originated, but is unique across ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-optimization.html
Applications that monitor databases may make frequent use of Performance Schema tables. To write queries for these tables most efficiently, take advantage of their indexes. For example, include a WHERE clause that restricts retrieved rows based on ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-functions.html
PS_CURRENT_THREAD_ID() Returns a BIGINT UNSIGNED value representing the Performance Schema thread ID assigned to the current connection. PS_THREAD_ID(connection_id) Given a connection ID, returns a BIGINT UNSIGNED value representing the Performance ... MySQL includes built-in SQL functions that format or retrieve Performance Schema data, and that may be used as equivalents for the corresponding sys schema stored ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-limitations.html
This section discusses current restrictions and limitations on MySQL partitioning support. The following constructs are not permitted in partitioning expressions: Stored procedures, stored functions, loadable functions, or plugins. For a list of ...
https://dev.mysql.com/doc/refman/9.7/en/optimizing-innodb-bulk-data-loading.html
For optimal performance when loading data into an InnoDB FULLTEXT index, follow this set of steps: Define a column FTS_DOC_ID at table creation time, of type BIGINT UNSIGNED NOT NULL, with a unique index named FTS_DOC_ID_INDEX. For example: CREATE ... These performance tips supplement the general guidelines for fast inserts in Section 10.2.5.1, “Optimizing INSERT ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-routines.html
Two functions, listed here, provide JavaScript Function objects reflecting MySQL stored routines: getFunction(): Get a Function instance given the name of a stored function. getProcedure(): Get a Function instance given the name of a stored ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-command-options.html
In the following example, table t1 has a single column of type BIGINT and containing 4 rows. The output when using the --quick option is 25 characters wide; this is equal to the number of characters needed to represent -9223372036854775808, which is ... mysql supports the following options, which can be specified on the command line or in the [mysql] and [client] groups of an option ...