I am inserting data in MySQL into the contacts module/table from another tables, but the ‘contacts’ table does not have an email address column. I see that ‘contacts_cstm’ and ‘contacts’ have a primary key ‘id’, but when I look at the email tables, I cannot find the corresponding primary key between contacts and email addresses.
So my question is how do I write the query that adds emails from my table to the contact’s emails table in SuiteCRM?
Below is the query I use to insert most of the fields
INSERT INTO contacts(
id,
first_name,
last_name,
photo,
phone_home,
phone_mobile,
phone_fax,
primary_address_street,
primary_address_city,
primary_address_state,
primary_address_postalcode,
birthdate,
/*email would ideally go here in this query*/
)
SELECT
ClientID,
Firstname,
Lastname,
Photo,
Homephone,
Mobilephone,
Fax,
Address,
City,
`State/Prov`,
Zipcode,
DoB,
Email1 ,
FROM
exampletable;