insert data into colums of different tables

[P Soman]

How can I insert data into two or more tables which having same column name ?

Thanks

 

[vacunita]

Since you cannot insert into multiple tables with a single Insert statement, you would need to run multiple Insert statements, each inserting into a specific table, and then as such, each statement knows exactly what table and column it will insert into.






----------------------------------
Phil AKA Vacunita
----------------------------------
OS-ception: Running Linux on a Virtual Machine in Windows which itself is running in a Virtual Machine on Mac OSx.

Web & Tech

 

[spamjim]

https://dev.mysql.com/doc/refman/8.0/en/commit.html

Wrap these multiple statements in a transaction so if something fails, you can rollback/cancel the entirety.