PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/fetching-spatial-data.html
Fetching spatial data in internal format: Fetching geometry values using internal format can be useful in table-to-table transfers: CREATE TABLE geom2 (g GEOMETRY) SELECT g FROM geom; Fetching spatial data in WKT format: The ST_AsText() function ...
https://dev.mysql.com/doc/refman/5.7/en/fractional-seconds.html
Previously, the temporal type keyword was ignored and these constructs produced the string value. MySQL has fractional seconds support for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision: To define a column that ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-system-tables.html
The following table name aliases are used to shorten the query string: INFORMATION_SCHEMA.INNODB_SYS_TABLES: a INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES: b INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS: c An IF() control flow function is used to account ...MB values are rounded to zero decimal spaces using the ROUND() ... You can extract metadata about schema ...
https://dev.mysql.com/doc/refman/5.7/en/ipv6-support.html
For example: mysql> CREATE USER 'bill'@'::1' IDENTIFIED BY 'secret'; mysql> GRANT SELECT ON mydb.* TO 'bill'@'::1'; IPv6 functions enable conversion between string and internal format IPv6 address formats, and checking whether values represent valid ... Support for IPv6 in MySQL includes these capabilities: MySQL Server can accept TCP/IP connections from clients connecting over ...
https://dev.mysql.com/doc/refman/5.7/en/replication-channels.html
To provide compatibility with previous versions, the MySQL server automatically creates on startup a default channel whose name is the empty string (""). If no other channels (having nonempty names) have been created, replication statements act on ... In MySQL multi-source replication, a replica opens multiple replication channels, one for each replication source ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-object-index.html
The following tables list sys schema objects and provide a short description of each one.
https://dev.mysql.com/doc/refman/5.7/en/two-digit-years.html
To specify zero for YEAR and have it be interpreted as 2000, specify it as a string '0' or '00'. Some functions like MIN() and MAX() convert a YEAR to a number. This means that a value with a 2-digit year does not work properly with these functions.
https://dev.mysql.com/doc/refman/5.7/en/audit-log-disabling.html
The audit_log_disable variable can be set in a MySQL Server option file, in a command-line startup string, or at runtime using a SET statement; for example: SET GLOBAL audit_log_disable = true; Setting audit_log_disable to true disables the audit ...
https://dev.mysql.com/doc/refman/5.7/en/begin-end.html
END syntax is used for writing compound statements, which can appear within stored programs (stored procedures and functions, triggers, and events). Use of multiple statements requires that a client is able to send statement strings containing the ; ...A compound statement can contain multiple statements, enclosed by the BEGIN and END ...
https://dev.mysql.com/doc/refman/5.7/en/charset-conversion.html
To convert a binary or nonbinary string column to use a particular character set, use ALTER TABLE. To remove these bytes, use the TRIM() function: UPDATE t SET col1 = TRIM(TRAILING 0x00 FROM col1); Suppose that table t has a nonbinary column named ...For successful conversion to occur, one of the following conditions must apply: If the column has a binary data type (BINARY, VARBINARY, BLOB), all the values that it contains must be encoded using a single character set (the character set you're converting the column ...