mysql - INSERT data into a table only if it matches a field in another table -
i have data want import mysql db if there matching email address in table two.
insert table_1 value data_1, email email *exists in table_2*
i not sure if explaining correctly if need more info let me know.
thanks!
insert table1(data_1, email) values (select data_1,email table_2 table_1.email=table2.email)