Articles & Code Snippets


Compare tables find and update in MySQL

Compare two tables find and update only matching data in MySQL


Find:
SELECT id, mailing
FROM directory_list a
JOIN email_temp b ON a.email=b.email;
Update:
UPDATE directory_list a
JOIN email_temp b ON a.email=b.email
SET mailing = concat(COALESCE(mailing, ''), ' --text--');
web


Archives

Just feel like saying Hi?

  1 (903) NEGRARU phone
  email