PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/audit-log-restrictions.html
Only top-level statements are logged, not statements within stored programs such as triggers or stored procedures. MySQL Enterprise Audit is subject to these general restrictions: Only SQL statements are logged. Changes made by no-SQL APIs, such as ...
https://dev.mysql.com/doc/refman/8.0/en/begin-end.html
END syntax is used for writing compound statements, which can appear within stored programs (stored procedures and functions, triggers, and events). A compound statement can contain multiple statements, enclosed by the BEGIN and END keywords.
https://dev.mysql.com/doc/refman/8.0/en/binary-log-mixed.html
When one or more tables with AUTO_INCREMENT columns are updated and a trigger or stored function is invoked. When running in MIXED logging format, the server automatically switches from statement-based to row-based logging under the following ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log-setting.html
There are exceptions when you cannot switch the replication format at runtime: The replication format cannot be changed from within a stored function or a trigger. You can select the binary logging format explicitly by starting the MySQL server ...
https://dev.mysql.com/doc/refman/8.0/en/check-table.html
option: { FOR UPGRADE | QUICK | FAST | MEDIUM | EXTENDED | CHANGED } CHECK TABLE checks a table or tables for errors. CHECK TABLE can also check views for problems, such as tables that are referenced in the view definition that no longer exist. To ...
https://dev.mysql.com/doc/refman/8.0/en/comments.html
Beginning with MySQL 8.0.34, if this condition is not met, the statement triggers a warning ; you should expect this requirement to become strictly enforced in a future version of MySQL. MySQL Server supports three comment styles: From a # ...
https://dev.mysql.com/doc/refman/8.0/en/commit.html
Note Within all stored programs (stored procedures and functions, triggers, and events), the parser treats BEGIN [WORK] as the beginning of a BEGIN ... SET autocommit disables or enables the default autocommit mode for the current session. This ...
https://dev.mysql.com/doc/refman/8.0/en/create-procedure.html
If you are calling the procedure from within a trigger, you can also pass NEW.col_name as an OUT or INOUT parameter. By default, a stored routine is associated with the default database. To associate the routine explicitly with a given database, ...
https://dev.mysql.com/doc/refman/8.0/en/create-table.html
| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ... | [CONSTRAINT [symbol]] UNIQUE [INDEX | KEY] [index_name] [index_type] (key_part,...) [index_option] ... (Some valid select or union statement) CREATE TABLE creates ...
https://dev.mysql.com/doc/refman/8.0/en/create-view.html
If the view does not exist, CREATE OR REPLACE VIEW is the same as CREATE VIEW. If the view does exist, CREATE OR REPLACE VIEW replaces it. For information about restrictions on view use, see Section 27.9, “Restrictions on Views”. The ...