PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/drop-function-loadable.html
It requires the DELETE privilege for the mysql system database because it removes the row from the mysql.func system table that registers the function. DROP FUNCTION [IF EXISTS] function_name This statement drops the loadable function named ...
https://dev.mysql.com/doc/refman/5.7/en/drop-table.html
They are permitted to make porting easier from other database systems. Be careful with this statement! For each table, it removes the table definition and all table data. If the table is partitioned, the statement removes the table definition, all ...
https://dev.mysql.com/doc/refman/5.7/en/drop-trigger.html
DROP TRIGGER [IF EXISTS] [schema_name.]trigger_name This statement drops a trigger. If the schema is omitted, the trigger is dropped from the default schema. DROP TRIGGER requires the TRIGGER privilege for the table associated with the trigger. Use ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption-installation.html
The CREATE FUNCTION and DROP FUNCTION statements require the INSERT and DROP privilege, respectively, for the mysql database. MySQL Enterprise Encryption functions are located in a loadable function library file installed in the plugin directory ...
https://dev.mysql.com/doc/refman/5.7/en/error-interfaces.html
Also, if the database administrator changes the language setting, that affects the language of message strings; see Section 10.12, “Setting the Error Message Language”. Error messages can originate on the server side or the client side, and ...
https://dev.mysql.com/doc/refman/5.7/en/event-scheduler.html
The MySQL Event Scheduler manages the scheduling and execution of events, that is, tasks that run according to a schedule. The following discussion covers the Event Scheduler and is divided into the following sections: Section 23.4.1, “Event ...
https://dev.mysql.com/doc/refman/5.7/en/events-configuration.html
Events are executed by a special event scheduler thread; when we refer to the Event Scheduler, we actually refer to this thread. When running, the event scheduler thread and its current state can be seen by users having the PROCESS privilege in the ...
https://dev.mysql.com/doc/refman/5.7/en/events-privileges.html
For example, to remove the event e_insert shown previously, root can use the following statement: DELETE FROM mysql.event WHERE db = 'myschema' AND name = 'e_insert'; It is very important to match the event name and database schema name when ... To ...
https://dev.mysql.com/doc/refman/5.7/en/events-syntax.html
An event can be dropped by any user having the EVENT privilege for the database on which the event is defined. MySQL provides several SQL statements for working with scheduled events: New events are defined using the CREATE EVENT statement. The ...
https://dev.mysql.com/doc/refman/5.7/en/example-storage-engine.html
When you create an EXAMPLE table, the server creates a table format file in the database directory. The EXAMPLE storage engine is a stub engine that does nothing. Its purpose is to serve as an example in the MySQL source code that illustrates how ...