2018-12-19, 09:28 AM
Hello everybody.
I have a problem. In my database I need to delete special rows of duplicated contractors from "contractors" table. Last (which always have the same individual vat_number) added duplicated contractor must only stay. Any other rows with duplicated contractor_id are to delete.
Second thing is that this old contractors (contractor_id) are in invoices in the second table "orders". I need a script to connect to mysql database and find all invoices having old contractor id and replace it all to last created contractor_id with the same vat_number.
Can somebody help me with this?
Here's the example:
![[Image: mysql_tables.jpg]](https://camo.mybb.com/772c4edbceec7e471edf36f42d9c775b856fca47/687474703a2f2f736b6c65702e63657274706f6c2e706c2f66696c65732f6d7973716c5f7461626c65732e6a7067)
I have a problem. In my database I need to delete special rows of duplicated contractors from "contractors" table. Last (which always have the same individual vat_number) added duplicated contractor must only stay. Any other rows with duplicated contractor_id are to delete.
Second thing is that this old contractors (contractor_id) are in invoices in the second table "orders". I need a script to connect to mysql database and find all invoices having old contractor id and replace it all to last created contractor_id with the same vat_number.
Can somebody help me with this?
Here's the example: