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-database.html
See Section 13.1.16, “CREATE PROCEDURE and CREATE FUNCTION Statements”.) If you change the default character set or collation for a database, any stored routines that are to use the new defaults must be dropped and recreated. ALTER {DATABASE | ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table-generated-columns.html
As of MySQL 5.7.10, if expression evaluation causes truncation or provides incorrect input to a function, the ALTER TABLE statement terminates with an error and the DDL operation is rejected. ALTER TABLE operations permitted for generated columns ...
https://dev.mysql.com/doc/refman/5.7/en/any-in-some-subqueries.html
The expression is TRUE if table t2 contains (21,14,7) because there is a value 7 in t2 that is less than 10. The expression is FALSE if table t2 contains (20,10), or if table t2 is empty. The expression is unknown (that is, NULL) if table t2 ...
https://dev.mysql.com/doc/refman/5.7/en/apis-ruby-mysqlruby.html
For information on installing the module, and the functions exposed, see MySQL/Ruby. The MySQL/Ruby module provides access to MySQL databases using Ruby through libmysqlclient.
https://dev.mysql.com/doc/refman/5.7/en/apis-ruby-rubymysql.html
For information on installing the module, and the functions exposed, see Ruby/MySQL. The Ruby/MySQL module provides access to MySQL databases using Ruby through a native driver interface using the MySQL network protocol.
https://dev.mysql.com/doc/refman/5.7/en/archive-storage-engine.html
The ARCHIVE storage engine produces special-purpose tables that store large amounts of unindexed data in a very small footprint. To enable this storage engine if you build MySQL from source, invoke CMake with the -DWITH_ARCHIVE_STORAGE_ENGINE ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-elements.html
A set of functions enables manipulation of filtering definitions that control logging behavior, the encryption password, and log file reading. MySQL Enterprise Audit is based on the audit log plugin and related elements: A server-side plugin named ...
https://dev.mysql.com/doc/refman/5.7/en/calculating-days.html
The following example shows how you can use the bit group functions to calculate the number of days per month a user has visited a Web page. CREATE TABLE t1 (year YEAR, month INT UNSIGNED, day INT UNSIGNED); INSERT INTO t1 ...
https://dev.mysql.com/doc/refman/5.7/en/case.html
CASE case_value WHEN when_value THEN statement_list [WHEN when_value THEN statement_list] ... [ELSE statement_list] END CASE Or: CASE WHEN search_condition THEN statement_list [WHEN search_condition THEN statement_list] ... [ELSE statement_list] ...
https://dev.mysql.com/doc/refman/5.7/en/channels-commands-single-channel.html
To enable MySQL replication operations to act on individual replication channels, use the FOR CHANNEL channel clause with the following replication statements: CHANGE MASTER TO START SLAVE STOP SLAVE SHOW RELAYLOG EVENTS FLUSH RELAY LOGS SHOW SLAVE ...