PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/alter-table.html
For example, if you shorten a string column, values may be truncated. ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-filter-definitions.html
READ delete event: DELETE TRUNCATE TABLE insert event: INSERT INSERT ... For information about using JSON data in MySQL, see Section 11.5, “The JSON Data Type”. Filter definitions have this form, where actions indicates how filtering takes ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-logging-configuration.html
Prior to MySQL 5.7.21, only the XML log formats are available and the plugin performs rudimentary integrity checking: During initialization, the plugin checks whether the file ends with an </AUDIT> tag and truncates the tag before writing any ...
https://dev.mysql.com/doc/refman/5.7/en/binary-varbinary.html
If strict SQL mode is not enabled and you assign a value to a BINARY or VARBINARY column that exceeds the column's maximum length, the value is truncated to fit and a warning is generated. For cases of truncation, to cause an error to occur (rather ... The BINARY and VARBINARY types are similar to CHAR and VARCHAR, except that they store binary strings rather than nonbinary ...
https://dev.mysql.com/doc/refman/5.7/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 12.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/5.7/en/create-server.html
server_name has a maximum length of 64 characters (names longer than 64 characters are silently truncated), and is case-insensitive. CREATE SERVER server_name FOREIGN DATA WRAPPER wrapper_name OPTIONS (option [, option] ...) option: { HOST ...
https://dev.mysql.com/doc/refman/5.7/en/drop-tablespace.html
As with the InnoDB system tablespace, truncating or dropping InnoDB tables stored in a general tablespace creates free space in the tablespace .ibd data file, which can only be used for new InnoDB data. Similar to the system tablespace, truncating ... DROP TABLESPACE tablespace_name [ENGINE [=] engine_name] This statement drops a tablespace that was previously created using CREATE ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-cjk.html
With utf8, MySQL must truncate an input string when it encounters bytes that it does no understand. This set of Frequently Asked Questions derives from the experience of MySQL's Support and Development groups in handling many inquiries about CJK ...
https://dev.mysql.com/doc/refman/5.7/en/firewall-usage.html
Before using MySQL Enterprise Firewall, install it according to the instructions provided in Section 6.4.6.2, “Installing or Uninstalling MySQL Enterprise Firewall”. Also, MySQL Enterprise Firewall does not work together with the query cache; ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-boolean.html
If a word is specified with the truncation operator, it is not stripped from a boolean query, even if it is too short or a stopword. MySQL can perform boolean full-text searches using the IN BOOLEAN MODE modifier. With this modifier, certain ...