db = mariadb.connect(...)

qr = db.cursor(buffered=True)

qr.execute('create temporary table temp (a int unsigned)')

qr.execute('insert into temp values (1), (2), (3)')

qr.execute('select a from temp')

db.commit()

qr.fetchall()

Traceback (most recent call last):

  File "<input>", line 1, in <module>

    qr.fetchall()

mariadb.ProgrammingError: Cursor doesn't have a result set

qr.execute('select a from temp where a > ?', (0, ))

db.commit()

qr.fetchall()

[(1,), (2,), (3,)]