Keep It Simple, Stupid | |
PerlMonks |
Re: DBI/MySQL/MariaDB clone tables across DB Connectionsby NERDVANA (Deacon) |
on Feb 17, 2023 at 06:11 UTC ( [id://11150470]=note: print w/replies, xml ) | Need Help?? |
If I were doing this with DBIC, it would be as simple as making two connections, and then:
assuming you can disable the foreign key checks on the temporary table. If you can't, you'd have to sort the rows so parents come before children, and then that gets more complicated if there is a auto-increment ID column.
In Section
Seekers of Perl Wisdom
|
|