Details
-
Type:
New Feature
-
Status: Closed (View Workflow)
-
Priority:
Minor
-
Resolution: Not a Bug
-
Affects Version/s: 1.0.6
-
Fix Version/s: N/A
-
Component/s: DBAPI 2.0
-
Labels:None
Description
How can I execute a sql script with mariadb connector? (create a trigger for example , with delimiter and ; inside trigger body)
https://mariadb-corporation.github.io/mariadb-connector-python/connection.html
does not mention anything about multiple statements.
https://mariadb-corporation.github.io/mariadb-connector-python/cursor.html describes nextset() method (So, I assume multiple statements is possible).
A simple
crsr.execute('select 1; select 2') returns a ProgrammingError.
crsr.execute('delimiter $$') also returns error.