Search Results
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-stored-procedures.html
Putting database-intensive operations into stored procedures lets you define an API for your database application. Before working through this tutorial, familiarize yourself with the CREATE PROCEDURE and CREATE FUNCTION statements that create ...You ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-stored-procedures.html
Putting database-intensive operations into stored procedures lets you define an API for your database application. Before working through this tutorial, familiarize yourself with the CREATE PROCEDURE and CREATE FUNCTION statements that create ...You ...
https://dev.mysql.com/doc/refman/8.4/en/drop-logfile-group.html
DROP LOGFILE GROUP logfile_group ENGINE [=] engine_name This statement drops the log file group named logfile_group. (For information on creating log file groups, see Section 15.1.16, “CREATE LOGFILE GROUP Statement”.) Important Before dropping ...The log file group must already exist or an error ...
https://dev.mysql.com/doc/refman/8.4/en/drop-spatial-reference-system.html
DROP SPATIAL REFERENCE SYSTEM [IF EXISTS] srid srid: 32-bit unsigned integer This statement removes a spatial reference system (SRS) definition from the data dictionary. Example: DROP SPATIAL REFERENCE SYSTEM 4120; If no SRS definition with the ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/en/drop-server.html
DROP SERVER [ IF EXISTS ] server_name Drops the server definition for the server named server_name. Dropping a server for a table does not affect any FEDERATED tables that used this connection information when they were created. DROP SERVER is not ...
https://dev.mysql.com/doc/refman/8.4/en/alter-procedure.html
However, you cannot change the parameters or body of a stored procedure using this statement; to make such changes, you must drop and re-create the procedure using DROP PROCEDURE and CREATE PROCEDURE. ALTER PROCEDURE proc_name [characteristic ...] ...This behavior can be changed by disabling the automatic_sp_privileges system ...
https://dev.mysql.com/doc/refman/8.4/en/drop-event.html
DROP EVENT [IF EXISTS] event_name This statement drops the event named event_name. This statement requires the EVENT privilege for the schema to which the event to be dropped belongs. The event immediately ceases being active, and is deleted ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-drop-table.html
Usage ndb_drop_table -c connection_string tbl_name -d db_name Options that can be used with ndb_drop_table are shown in the following table. --connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-create-alter-drop-server.html
The statements CREATE SERVER, ALTER SERVER, and DROP SERVER are not written to the binary log, regardless of the binary logging format that is in use.