Compare tables find and update in MySQL
Posted by Cătălin on Thu, 22 Jun 2017
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 directory_list a
JOIN email_temp b ON a.email=b.email
SET mailing = concat(COALESCE(mailing, ''), ' --text--');
Archives
- May 2023 1
- April 2023 1
- March 2023 3
- January 2020 1
- November 2019 1
- September 2019 1
- April 2018 2
- February 2018 1
- January 2018 3
- December 2017 2
- November 2017 2
- October 2017 2
- September 2017 1
- July 2017 2
- June 2017 2
- May 2017 1
- March 2017 2
- February 2017 2
- January 2017 2
- November 2016 1
- October 2016 4
- August 2016 1
- April 2016 1
- June 2015 1
- May 2015 2
- April 2015 1
- December 2014 1
- October 2014 2
- September 2014 1
- July 2014 2
- June 2014 1
- March 2014 1
- February 2014 2
- January 2014 2
- December 2013 2
- October 2013 2
- September 2013 2
- July 2013 2
- June 2013 1
- March 2013 1
- February 2013 3
- January 2013 1
- December 2012 1
- November 2012 1
- September 2012 1
- August 2012 2
- April 2012 1
- August 2011 2
- July 2011 2
- January 2011 1
- October 2010 5
- August 2010 2
- July 2010 3
- May 2010 1
- April 2010 5
- March 2010 3
- February 2010 2