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/gis-format-conversion-functions.html
There are also functions to convert a string from WKT or WKB format to internal geometry format. ST_AsText(g), ST_AsWKT(g) Converts a value in internal geometry format to its WKT representation and returns the string result. mysql> SET @g = ...
https://dev.mysql.com/doc/refman/5.7/en/charset-binary-set.html
The binary character set is the character set for binary strings, which are sequences of bytes. For the binary character set, the concepts of lettercase and accent equivalence do not apply: For single-byte characters stored as binary strings, ...
https://dev.mysql.com/doc/refman/5.7/en/delete.html
For example, to delete rows that exist in t1 that have no match in t2, use a LEFT JOIN: DELETE t1 FROM t1 LEFT JOIN t2 ON t1.id=t2.id WHERE t2.id IS NULL; The syntax permits .* after each tbl_name for compatibility with Access. DELETE is a DML ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-index-cache-table.html
The INNODB_FT_INDEX_CACHE table provides token information about newly inserted rows in a FULLTEXT index. Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-index-table-table.html
The INNODB_FT_INDEX_TABLE table provides information about the inverted index used to process text searches against the FULLTEXT index of an InnoDB table. Before querying it, set the value of the innodb_ft_aux_table system variable to the name ...
https://dev.mysql.com/doc/refman/5.7/en/truncate-table.html
TRUNCATE TABLE can be used with Performance Schema summary tables, but the effect is to reset the summary columns to 0 or NULL, not to remove rows. Logically, TRUNCATE TABLE is similar to a DELETE statement that deletes all rows, or a sequence of ...
https://dev.mysql.com/doc/refman/5.7/en/hexadecimal-literals.html
For example, a hexadecimal literal assigned to a user-defined variable is a binary string by default. The 0x notation is based on ODBC, for which hexadecimal strings are often used to supply values for BLOB columns. To convert a string or a number ... Hexadecimal literal values are written using X'val' or 0xval notation, where val contains hexadecimal digits (0..9, ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-parameters-table.html
The PARAMETER_NAME and PARAMETER_MODE values are NULL because the return value has no name and the mode does not apply. The PARAMETERS table provides information about parameters for stored routines (stored procedures and stored functions), and ...
https://dev.mysql.com/doc/refman/5.7/en/constraint-enum.html
The value cannot be the error value (that is, 0 or the empty string). A SET value must be the empty string or a value consisting only of the values listed in the column definition separated by commas. For SET, the value is inserted as given except ... ENUM and SET columns provide an efficient way to define columns that can contain only a given set of ...
https://dev.mysql.com/doc/refman/5.7/en/firewall-usage.html
To name an account for firewall operations, specify it as a single quoted string ('user_name@host_name'). The requirement for naming accounts as a single quoted string for firewall operations means that you cannot use accounts that have embedded @ ... Before using MySQL Enterprise Firewall, install it according to the instructions provided in Section 6.4.6.2, “Installing or Uninstalling MySQL Enterprise ...