How can I execute a sql script with mariadb connector? (create a trigger for example , with delimiter and ; inside trigger body)
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).
crsr.execute('select 1; select 2') returns a ProgrammingError.
crsr.execute('delimiter $$') also returns error.