Hello,
I am using free plan MySQL database. I have python code where i want to delete rows and then insert. Only the insert works. I can delete rows in Workbench using…
SET SQL_SAFE_UPDATES = 0;
DELETE FROM tablename
WHERE Start_Date >= ‘2024-06-21’;
SET SQL_SAFE_UPDATES = 1;
I have tried this in python code. But it only inserts, doesn’t delete.
Do I need to change settings in Aiven Console ?
Any help appreciated.