Details
-
New Feature
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Not a Bug
-
1.0.6
-
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.