PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/declare-condition.html
DECLARE condition_name CONDITION FOR condition_value condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value } The DECLARE ... CONDITION statement declares a named error condition, associating a name with a condition that needs ...
https://dev.mysql.com/doc/refman/5.7/en/disk-issues.html
If your computer is reasonably stable, this should give you better performance without sacrificing too much reliability. This section describes ways to configure storage devices when you can devote more and faster storage hardware to the database ...
https://dev.mysql.com/doc/refman/5.7/en/document-store.html
This differs from working with a relational database and storing products in a table, when all columns of the table must be known and defined before adding any products to the database. X DevAPI offers a modern programming interface with a simple ...
https://dev.mysql.com/doc/refman/5.7/en/drop-function-loadable.html
It requires the DELETE privilege for the mysql system database because it removes the row from the mysql.func system table that registers the function. During the normal startup sequence, the server loads functions registered in the mysql.func table. DROP FUNCTION [IF EXISTS] function_name This statement drops the loadable function named ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption-functions.html
If the arguments are not suitable to permit a function to perform the requested operation, it returns NULL or 0 as appropriate. Supported digest_type values: 'SHA224', 'SHA256', 'SHA384', 'SHA512' SET @dig = create_digest('SHA512', The quick brown ... MySQL Enterprise Encryption functions have these general characteristics: For arguments of the wrong type or an incorrect number of arguments, each function returns an ...
https://dev.mysql.com/doc/refman/5.7/en/error-creating-innodb.html
Initialization Problems If something goes wrong when InnoDB attempts to initialize its tablespace or its log files, delete all files created by InnoDB: all ibdata files and all ib_logfile files. If you already created some InnoDB tables, also delete ... The troubleshooting steps for InnoDB I/O problems depend on when the problem occurs: during startup of the MySQL server, or during normal operations when a DML or DDL statement fails due to problems at the file system ...
https://dev.mysql.com/doc/refman/5.7/en/error-interfaces.html
SHOW ENGINE INNODB STATUS statement output includes information about the most recent foreign key error if a CREATE TABLE statement for an InnoDB table fails. Error messages can originate on the server side or the client side, and each error ...
https://dev.mysql.com/doc/refman/5.7/en/events-overview.html
Whereas a trigger is a database object whose statements are executed in response to a specific type of event that occurs on a given table, a (scheduled) event is an object whose statements are executed in response to the passage of a specified time ... MySQL Events are tasks that run according to a ...
https://dev.mysql.com/doc/refman/5.7/en/firewall-elements.html
Server-side plugins named MYSQL_FIREWALL_USERS and MYSQL_FIREWALL_WHITELIST implement INFORMATION_SCHEMA tables that provide views into the registered profiles. Tables in the mysql system database provide persistent backing storage of firewall data.
https://dev.mysql.com/doc/refman/5.7/en/full-text-adding-collation.html
This section describes how to add a user-defined collation for full-text searches using the built-in full-text parser. The sample collation is like latin1_swedish_ci but treats the '-' character as a letter rather than as a punctuation character so ...