i have successfully connected my Odoo Erp to mysql and i export data from a table in Odoo to mysql.
I use Truncate then fetch from odoo and insert to mysql table. All good so far. After this i changed to Insert and update and for some weird reason it doest update the existing records but inserts them again. i do have set a unique field to look at in order to achive this but still.
My goal is to insert a new record when i have a new record in odoo or update existing record in mysql when something changes in odoo.