https://dev.mysql.com/stored-programs-logging.html
Triggers are similar to stored functions, so the preceding remarks regarding functions also apply to triggers with the following exception: CREATE TRIGGER does not have an optional DETERMINISTIC characteristic, so triggers are assumed to be always ... The binary log contains information about SQL statements that modify database ...
https://dev.mysql.com/string-comparison-functions.html
expr LIKE pat [ESCAPE 'escape_char'] Pattern matching using an SQL pattern. mysql> SELECT 'David!' LIKE 'David_'; -> 1 mysql> SELECT 'David!' LIKE '%D%v%'; -> 1 To test for literal instances of a wildcard character, precede it by the escape ...
https://dev.mysql.com/string-types.html
The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. For information about storage requirements of the string data types, see Section 11.7, “Data Type Storage Requirements”. For descriptions of functions that ...
https://dev.mysql.com/table-constraints-table.html
The TABLE_CONSTRAINTS table has these columns: CONSTRAINT_CATALOG The name of the catalog to which the constraint belongs. CONSTRAINT_SCHEMA The name of the schema (database) to which the constraint belongs. TABLE_SCHEMA The name of the schema ...
https://dev.mysql.com/user-defined-functions-table.html
The value is one of int, decimal, real, char, or row. The user_defined_functions table contains a row for each user-defined function (UDF) registered by a server component or plugin, or by a CREATE FUNCTION statement. user_defined_functions has ...
https://dev.mysql.com/writing-information-schema-plugins.html
This section describes how to write a server-side INFORMATION_SCHEMA table plugin. For example code that implements such plugins, see the sql/sql_show.cc file of a MySQL source distribution. You can also look at the example plugins found in the ...
