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/stored-routines-last-insert-id.html
Within the body of a stored routine (procedure or function) or a trigger, the value of LAST_INSERT_ID() changes the same way as for statements executed outside the body of these kinds of objects (see Section 14.15, “Information Functions”). The ...
https://dev.mysql.com/doc/refman/8.0/en/sys-sys-config-update-set-user.html
The sys_config_update_set_user trigger for the sys_config table is similar to the sys_config_insert_set_user trigger, but for UPDATE statements.
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-tables.html
The following sections describe sys schema tables and triggers. ...
https://dev.mysql.com/doc/refman/8.0/en/sys-sys-config-insert-set-user.html
For rows added to the sys_config table by INSERT statements, the sys_config_insert_set_user trigger sets the set_by column to the current user.
https://dev.mysql.com/doc/refman/8.0/en/stored-program-restrictions.html
SQL prepared statements (PREPARE, EXECUTE, DEALLOCATE PREPARE) can be used in stored procedures, but not in stored functions or triggers. Thus, stored functions and triggers cannot use dynamic SQL (where you construct statements as strings and then ...Some of the restrictions noted here apply to all stored routines; that is, both to stored procedures and stored ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html
--add-drop-trigger Command-Line Format --add-drop-trigger Write a DROP TRIGGER statement before each CREATE TRIGGER statement. --triggers Command-Line Format --triggers Disabled by skip-triggers Include triggers for each dumped table in the output.
https://dev.mysql.com/doc/refman/8.0/en/mysqlpump.html
mysqlpump requires at least the SELECT privilege for dumped tables, SHOW VIEW for dumped views, TRIGGER for dumped triggers, and LOCK TABLES if the --single-transaction option is not used. --exclude-triggers=trigger_list Command-Line Format ...
https://dev.mysql.com/doc/refman/8.0/en/lock-tables.html
If you lock a table explicitly with LOCK TABLES, any tables used in triggers are also locked implicitly, as described in LOCK TABLES and Triggers. Table Lock Acquisition Table Lock Release Interaction of Table Locking and Transactions LOCK TABLES ...
https://dev.mysql.com/doc/refman/8.0/en/stored-programs-logging.html
However, if logging occurs at the statement level, there are certain binary logging issues with respect to stored programs (stored procedures and functions, triggers, and events): In some cases, a statement might affect different sets of rows on ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbd-definition.html
In NDB 8.0, the use of IndexMemory in the cluster configuration file triggers a warning from the management server. A value between 0 and 100 inclusive is interpreted as a percent of the maximum default value, which is calculated based on a number ... The [ndbd] and [ndbd default] sections are used to configure the behavior of the cluster's data ...