Transaction on two db

hi , to do transaction i use this code 

[/CODE]
                    $db = \Config\Database::connect();

                    $db->transStart();
                             //CODE
                   $db->transComplete();


                    if($db->transStatus()!==false) {

                        //CODE show message ok

                    }else{

                         //CODE show message error
                    }

[/CODE]

I must copy value from one table's db (on same server ) to another db table from another db

• truncate table dbA_tableMaterial
  
• SELECT * FROM table dbB_tableMaterial
  
• foreach value of mysql select insert value on table dbA_tableMaterial
  

It's possble use transaction ?

Not positive but maybe nested transactions.

CodeIgniter 4 User Guide - Transactions - Nested Transactions

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )

See https://stackoverflow.com/questions/3399...with-mysql

ci-phpunit-test | CodeIgniter Testing Guide | CodeIgniter 3 to 4 Upgrade Helper