PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/event-scheduler.html
Section 27.4.6, “The Event Scheduler and MySQL Privileges”, discusses the privileges required to work with events and the ramifications that events have with regard to privileges when executing. The MySQL Event Scheduler manages the scheduling ...
https://dev.mysql.com/doc/refman/8.0/en/events-status-info.html
The Event Scheduler writes information about event execution that terminates with an error or warning to the MySQL Server's error log. See Section 27.4.6, “The Event Scheduler and MySQL Privileges” for an example. For frequently executed ...
https://dev.mysql.com/doc/refman/8.0/en/events-syntax.html
MySQL provides several SQL statements for working with scheduled events: New events are defined using the CREATE EVENT statement. The definition of an existing event can be changed by means of the ALTER EVENT statement. When a scheduled event is no ...
https://dev.mysql.com/doc/refman/8.0/en/example-storage-engine.html
mysql> CREATE TABLE test (i INT) ENGINE = EXAMPLE; Query OK, 0 rows affected (0.78 sec) mysql> INSERT INTO test VALUES(1),(2),(3); ERROR 1031 (HY000): Table storage engine for 'test' doesn't » have this option mysql> SELECT * FROM test; Empty set ... The EXAMPLE storage engine is a stub engine that does ...
https://dev.mysql.com/doc/refman/8.0/en/example-user-variables.html
You can employ MySQL user variables to remember results without having to store them in temporary variables in the client.
https://dev.mysql.com/doc/refman/8.0/en/examples.html
Here are examples of how to solve some common problems with MySQL. Some of the examples use the table shop to hold the price of each article (item number) for certain traders (dealers). Supposing that each trader has a single fixed price per ...
https://dev.mysql.com/doc/refman/8.0/en/except.html
query_expression_body EXCEPT [ALL | DISTINCT] query_expression_body [EXCEPT [ALL | DISTINCT] query_expression_body] [...] query_expression_body: See Section 15.2.14, “Set Operations with UNION, INTERSECT, and EXCEPT” EXCEPT limits the result ...
https://dev.mysql.com/doc/refman/8.0/en/expired-password-handling.html
} Other MySQL Connectors have their own conventions for indicating readiness to handle sandbox mode. MySQL provides password-expiration capability, which enables database administrators to require that users reset their password. Passwords can be ...
https://dev.mysql.com/doc/refman/8.0/en/explain-extended.html
The EXPLAIN statement produces extra (“extended”) information that is not part of EXPLAIN output but can be viewed by issuing a SHOW WARNINGS statement following EXPLAIN. As of MySQL 8.0.12, extended information is available for SELECT, DELETE, ...
https://dev.mysql.com/doc/refman/8.0/en/extensions-to-ansi.html
Consequently, database and table names are case-sensitive in MySQL Server on operating systems that have case-sensitive file names (such as most Unix systems). MySQL Server supports some extensions that you are not likely to find in other SQL DBMSs. Be warned that if you use them, your code is most likely not portable to other SQL ...