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/signal.html
Valid simple_value_specification designators can be specified using stored procedure or function parameters, stored program local variables declared with DECLARE, user-defined variables, system variables, or literals. The warning does not terminate ...SIGNAL provides error information to a handler, to an outer portion of the application, or to the ...
https://dev.mysql.com/doc/refman/8.0/en/alter-database.html
See Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”.) If you change the default character set or collation for a database, any stored routines that are to use the new defaults must be dropped and recreated. Stored routines: ...
https://dev.mysql.com/doc/refman/8.0/en/trigger-syntax.html
There are limitations on what can appear in statements that a trigger executes when activated: The trigger cannot use the CALL statement to invoke stored procedures that return data to the client or that use dynamic SQL. (Stored procedures are ...
https://dev.mysql.com/doc/refman/8.0/en/flush.html
However, you may use FLUSH in stored procedures, so long as these are not called from stored functions or triggers. Note It is not possible to issue FLUSH statements within stored functions or triggers. For information about prepared statement ...| ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-commands.html
This behavior on the server side comes into play for multiple-statement execution (see Multiple Statement Execution Support), and for parsing the body of stored procedures and functions, triggers, and events (see Section 27.1, “Defining Stored ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-statement-summary-tables.html
Each row summarizes events for a given stored program (stored procedure or function, trigger, or event). The events_statements_summary_by_program table has these additional summary columns: COUNT_STATEMENTS, SUM_STATEMENTS_WAIT, MIN_STATEMENTS_WAIT, ... The Performance Schema maintains tables for collecting current and recent statement events, and aggregates that information in summary ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log.html
After a backup has been restored, the events in the binary log that were recorded after the backup was made are re-executed. However, the benefits of the binary log in enabling you to set up replication and for restore operations generally outweigh ... The binary log contains “events” that describe database changes such as table creation operations or changes to table ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-foreign-keys.html
NDB Cluster stores foreign names using the same lettercase with which they are created. Prior to version 8.0.20, when processing SELECT and other SQL statements, NDB compared the names of foreign keys in such statements with the names as stored in a ... MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data ...
https://dev.mysql.com/doc/refman/8.0/en/create-trigger.html
If the DEFINER clause is present, the privileges required depend on the user value, as discussed in Section 27.6, “Stored Object Access Control”. If binary logging is enabled, CREATE TRIGGER might require the SUPER privilege, as discussed in ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-types.html
This is useful when you want to store a “possibly wrong” value which the user has specified (for example, in a web form) in the database for future processing. MySQL permits you to store dates where the day or month and day are zero in a DATE or ... The date and time data types for representing temporal values are DATE, TIME, DATETIME, TIMESTAMP, and ...