PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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 Yes 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/9.7/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/9.7/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/9.7/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/9.7/en/mysql-cluster-programs-ndb-restore.html
--backupid=#, -b Command-Line Format --backupid=# Type Numeric Default Value none This option is required; it 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 ... 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/9.7/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 ...
https://dev.mysql.com/doc/refman/9.7/en/secure-client-programming.html
The simplest way to protect from this type of attack is to use single quotation marks around the numeric constants: SELECT * FROM table WHERE ID='234'. In a numeric context, MySQL automatically converts this string to a number and strips any ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-columns-table.html
The related ST_GEOMETRY_COLUMNS table provides information about table columns that store spatial data. The COLUMNS table has these columns: TABLE_CATALOG The name of the catalog to which the table containing the column belongs. TABLE_SCHEMA The ...