Search Results
https://dev.mysql.com/doc/refman/8.4/en/declare.html
Variable and condition declarations must appear before cursor or handler declarations. The DECLARE statement is used to define various items local to a program: Local variables. END compound statement and must be at its start, before any other ...
https://dev.mysql.com/doc/refman/8.4/en/signal.html
SIGNAL Overview Signal Condition Information Items Effect of Signals on Handlers, Cursors, and Statements SIGNAL Overview The condition_value in a SIGNAL statement indicates the error value to be returned. Some signal values cause statement ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-performance-extensions.html
Default Value true Since Version 3.1.9 useCursorFetch Should the driver use cursor-based fetching to retrieve rows? If set to "true" and 'defaultFetchSize' is set to a value higher than zero or 'setFetchSize()' with a value higher than zero is ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-errors-integrityerror.html
The following example shows a duplicate key error raised as IntegrityError: cursor.execute("CREATE TABLE t1 (id int, PRIMARY KEY (id))") try: cursor.execute("INSERT INTO t1 (id) VALUES (1)") cursor.execute("INSERT INTO t1 (id) VALUES (1)") except ...
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. Result sets produced by the stored procedure are automatically fetched and stored as MySQLCursorBuffered instances.
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursor-fetchsets.html
Syntax: for statement, result_set in cursor.fetchsets(): # do something with statement and/or result set This method generates a set of result sets caused by the last cursor.execute*(). sql_operation = ''' SET @a=1, @b='2025-01-01'; SELECT @a, ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-errors-integrityerror.html
The following example shows a duplicate key error raised as IntegrityError: cursor.execute("CREATE TABLE t1 (id int, PRIMARY KEY (id))") try: cursor.execute("INSERT INTO t1 (id) VALUES (1)") cursor.execute("INSERT INTO t1 (id) VALUES (1)") except ...
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. Result sets produced by the stored procedure are automatically fetched and stored as MySQLCursorBuffered instances.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-fetchsets.html
Syntax: for statement, result_set in cursor.fetchsets(): # do something with statement and/or result set This method generates a set of result sets caused by the last cursor.execute*(). sql_operation = ''' SET @a=1, @b='2025-01-01'; SELECT @a, ...
https://dev.mysql.com/doc/relnotes/connector-python/en/news-8-0-30.html
(Bug #34231226) C extension and pure Python cursor types are not interchangeable when using connection objects that are not of the same type; now we check for supported cursor classes and raise a ProgrammingError if the cursor is not of a compatible ... Functionality Added or Changed Bugs Fixed Functionality Added or Changed Added support for OpenSSL ...