Can we insert data into two different tables using mysql/sql ?

Answer 1

make two queries 😉

Answer 2

no

Answer 3

yes you can using MySQLi not the legacy MySQL

Answer 4

yes u can

Answer 5

Do you mean it needs in one transaction?

Answer 6

I would run the insert for one table and then use search and replace on the table name using ctrl+h as long as the columns are the same name otherwise you have to do a search and replace on the column names too.

once you have completed the search and replace rerun the query