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/encryption-functions.html
One benefit of having a set of default keys is that it gives applications a way to check for the existence of encrypted column values, without giving the end user the right to decrypt those values. If you want to store these results, use a column ...
https://dev.mysql.com/doc/refman/5.7/en/engine-condition-pushdown-optimization.html
This optimization improves the efficiency of direct comparisons between a nonindexed column and a constant. In such cases, the condition is “pushed down” to the storage engine for evaluation. This optimization can be used only by the NDB ...
https://dev.mysql.com/doc/refman/5.7/en/error-creating-innodb.html
Runtime Problems If InnoDB prints an operating system error during a file operation, usually the problem has one of the following solutions: Make sure the InnoDB data file directory and the InnoDB log directory exist. The troubleshooting steps for ...
https://dev.mysql.com/doc/refman/5.7/en/error-interfaces.html
$> ndb_perror 323 NDB error code 323: Invalid nodegroup id, nodegroup already existing: Permanent error: Application error . Error messages can originate on the server side or the client side, and each error message includes an error code, SQLSTATE ...
https://dev.mysql.com/doc/refman/5.7/en/error-message-elements.html
This section discusses how error messages originate within MySQL and the elements they contain. Error Message Sources Error Message Elements Error Message Sources Error messages can originate on the server side or the client side: On the server ...
https://dev.mysql.com/doc/refman/5.7/en/event-scheduler.html
If you are upgrading to MySQL 5.7 from an earlier version, be sure to update your grant tables to make sure that the event table exists. The MySQL Event Scheduler manages the scheduling and execution of events, that is, tasks that run according to ...
https://dev.mysql.com/doc/refman/5.7/en/events-syntax.html
The definition of an existing event can be changed by means of the ALTER EVENT statement. MySQL provides several SQL statements for working with scheduled events: New events are defined using the CREATE EVENT statement. When a scheduled event is no ...
https://dev.mysql.com/doc/refman/5.7/en/example-auto-increment.html
You can also explicitly assign 0 to the column to generate sequence numbers, unless the NO_AUTO_VALUE_ON_ZERO SQL mode is enabled. For example: INSERT INTO animals (id,name) VALUES(0,'groundhog'); If the column is declared NOT NULL, it is also ...
https://dev.mysql.com/doc/refman/5.7/en/example-foreign-keys.html
MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data consistent. A foreign key relationship involves a parent table that holds the initial column ...
https://dev.mysql.com/doc/refman/5.7/en/expressions.html
This section lists the grammar rules that expressions must follow in MySQL and provides additional information about the types of terms that may appear in expressions. Expression Syntax Expression Term Notes Temporal Intervals Expression Syntax The ...