Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-asyncio.html
job_mysql: Connects to a MySQL server to perform operations such as queries and stored procedures. Installing Connector/Python also installs the mysql.connector.aio package that integrates asyncio with the connector to allow integrating ...
https://dev.mysql.com/doc/refman/8.4/en/trigger-syntax.html
To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 15.1.22, “CREATE TRIGGER Statement”, and Section 15.1.34, “DROP TRIGGER Statement”. You must specify the schema name if the ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/schema-advisor-ref.html
Default frequency 00:10:00 Default auto-close enabled no Object Changed: Database Has Been Dropped For development environments, changes to databases and objects may be a normal occurrence, but not for production environments. Default frequency ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursor-callproc.html
Syntax: result_args = cursor.callproc(proc_name, args=()) This method calls the stored procedure named by the proc_name argument. The args sequence of parameters must contain one entry for each argument that the procedure expects. Result sets ...To ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-callproc.html
Syntax: result_args = cursor.callproc(proc_name, args=()) This method calls the stored procedure named by the proc_name argument. The args sequence of parameters must contain one entry for each argument that the procedure expects. Result sets ...To ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-transaction-tables.html
Transactions and Stored Programs Transactions and stored program events are related as follows: Stored Procedures Stored procedures operate independently of transactions. A stored procedure can be started within a transaction, and a transaction can ...Within the event hierarchy, wait events nest within stage events, which nest within statement events, which nest within transaction ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-data-structures.html
MYSQL_FIELD structures are also used to provide metadata for OUT and INOUT parameters returned from stored procedures executed using prepared CALL statements. For a procedure parameter, the name of the database containing the procedure. This ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-invoked.html
The following statements are replicated using statement-based replication: CREATE EVENT ALTER EVENT DROP EVENT CREATE PROCEDURE DROP PROCEDURE CREATE FUNCTION DROP FUNCTION CREATE TRIGGER DROP TRIGGER However, the effects of features created, ...
https://dev.mysql.com/doc/refman/8.4/en/stored-routines-privileges.html
The ALTER ROUTINE privilege is needed to alter or drop stored routines. This privilege is granted automatically to the creator of a routine if necessary, and dropped from the creator when the routine is dropped. However, this privilege is granted ...
https://dev.mysql.com/doc/refman/8.4/en/extensions-to-ansi.html
See Section 15.1.12, “CREATE DATABASE Statement”, Section 15.1.24, “DROP DATABASE Statement”, and Section 15.1.2, “ALTER DATABASE Statement”. Use of CHANGE col_name, DROP col_name, or DROP INDEX, IGNORE or RENAME in ALTER TABLE ... MySQL ...