I have a table with 16,000 records and need to get out some columns and then insert values in multiples tables. For example, suppose I have the following tables
- tbl_1: id, name, lastname
- tbl_2: id, name
- tbl_3: id, lastname
I need to get the values from tbl_1 and then insert in tbl_2 and tbl_3 meaning tbl1.name goes to tbl_2.name and tbl_1.lastname goes to tbl3.lastname. Is this possible using SQL queries?
I'm using MySQL latest