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) 

Popular posts from this blog