Unable to create, update, insert in table.

[nefagi-01]

Hi everyone,

I am trying to use trino-python-client to create, update and insert into a table.
Even if I am able to do this from the basic Trino command line, this is not possible with trino-python-client.
Indeed with trino-python-client I am only able to select from the table, whereas all the queries containing insert, update or create are not executed.
How can I solve this??

[ebyhr]

Did you put fetchall() after execute() method? e.g.

    cur.execute('INSERT INTO sometable VALUES (4, 5, 6)')
    cur.fetchall()

[nefagi-01]

I didn't. Now I tried with cur.fetchall() and it works, thank you! 👍