PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/set.html
MySQL stores SET values numerically, with the low-order bit of the stored value corresponding to the first set member. If you retrieve a SET value in a numeric context, the value retrieved has bits set corresponding to the set members that make up ... A SET is a string object that can have zero or more values, each of which must be chosen from a list of permitted values specified when the table is ...
https://dev.mysql.com/doc/refman/8.0/en/string-functions.html
ASCII(str) Returns the numeric value of the leftmost character of the string str. A numeric argument is converted to its equivalent nonbinary string form. For a numeric argument N, HEX() returns a hexadecimal string representation of the value of N ...For functions that operate on string positions, the first position is numbered ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-filter-definitions.html
Table 8.40 audit_log_connection_policy_value Values Value Corresponding audit_log_connection_policy Value 0 or "::none" NONE 1 or "::errors" ERRORS 2 or "::all" ALL The "::xxx" values are symbolic pseudo-constants that may be given instead of the ...
https://dev.mysql.com/doc/refman/8.0/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/8.0/en/cast-functions.html
A common use for BINARY is to force a character string comparison to be done byte by byte using numeric byte values rather than character by character. Normally, sorting of ENUM columns occurs using the internal numeric values. For numeric operators ... Table 14.15 Cast Functions and Operators Name Description Deprecated BINARY Cast a string to a binary string 8.0.27 CAST() Cast a value as a certain type CONVERT() Cast a value as a certain type Cast functions and operators enable conversion of values from one data type to ...
https://dev.mysql.com/doc/refman/8.0/en/converting-tables-to-innodb.html
Consider using an auto-increment column if there is not another stable, unique, non-null, numeric column to use. Use the smallest practical numeric type based on the maximum projected size of the table. If you set up a numeric ID column for the ...
https://dev.mysql.com/doc/refman/8.0/en/glossary.html
Often used to save space and improve query performance by replacing repeated strings with numeric IDs, in a normalized data design. Thus, it is typically better to use arbitrary numeric values to form a synthetic key, for example using an ... These ...
https://dev.mysql.com/doc/refman/8.0/en/mathematical-functions.html
mysql> SELECT CEILING(1.23); -> 2 mysql> SELECT CEILING(-1.23); -> -1 For exact-value numeric arguments, the return value has an exact-value numeric type. mysql> SELECT FLOOR(1.23), FLOOR(-1.23); -> 1, -2 For exact-value numeric arguments, the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-restore.html
--backupid=#, -b Command-Line Format --backupid=# Type Numeric Default Value none This option is used to specify the ID or sequence number of the backup, and is the same number shown by the management client in the Backup backup_id completed message ... The NDB Cluster restoration program is implemented as a separate command-line utility ndb_restore, which can normally be found in the MySQL bin ...
https://dev.mysql.com/doc/refman/8.0/en/mysqld-safe.html
--mysqld-safe-log-timestamps Command-Line Format --mysqld-safe-log-timestamps=type Type Enumeration Default Value utc Valid Values systemhyphenlegacy This option controls the format for timestamps in log output produced by mysqld_safe. mysqld_safe ...