Insert to two table
I want to insert products to two different tables (product) and (translate) at the same time.
The product table contains all data.
The translate table contains unique translation fields, and is linked to the product table.
Step 1: Insert to product.
Step 2: Insert to translate. (When writing to this table, I want the id to be retrieved from product.pro_id and filled in translate.tra_proID.)
How do I do this?
Here are the tables:
product
———
pro_id
pro_name
translate
———
tra_id
tra_langID
tra_proID