Tuesday, December 10, 2013

insert and update with join and where cluse query in mysql[Solved]

Insert query example :
---------------------------
insert into cms_users(user_email,user_password,user_password_salt,user_activation_code,user_date_added)
select charity_contact_email,'25d896d7cb473deb61a752b845bdf548','WXaa','',now() from cms_charities
where charity_id in ( 
select charity_id  FROM cms_charities cc left join cms_users u on cc.charity_contact_email=u.user_email
where cc.charity_contact_email!='' and cc.charity_contact_email not in('sdowns@markomm.com','sarah.sievert@stbernardproject.org')
and u.user_email is null and cc.charity_submitted_by_user_id=0
)
Update query example :
-----------------------------
update cms_charities 
join cms_users
on cms_users.user_email=cms_charities.charity_contact_email
set cms_charities.charity_submitted_by_user_id=cms_users.user_id
WHERE cms_users.user_id>3367

No comments:

Post a Comment