Skip to content

$bLOG

some foobar

  • Home
  • Imprint
$bLOG

Tag: update

MySQL: UPDATE query based on SELECT query

update tableA a
left join tableB b on
    a.name_a = b.name_b
set
    validation_check = if(start_dts > end_dts, 'VALID', '')
UPDATE payments p 
    INNER JOIN users u ON
    p.pay_id=u.user_id
SET 
    p.pay_email=u.user_email, 
    p.pay_firstname=u.user_firstname, 
    p.pay_lastname=u.user_lastname, 
    p.pay_date=u.user_date
Via: stackoverflow.com
Author FabianPosted on 2015-09-272021-11-21Categories WebdevelopmentTags from, into, join, mysql, updateLeave a comment on MySQL: UPDATE query based on SELECT query

Recent Posts

  • Add a power LED to a Weller WE1010 soldering station
  • Microsoft Outlook – Cannot delete this folder
  • Mikrotik RouterOS WireGuard dynamic DNS endpoint refresh
  • C/C++/Arduino Datatypes
  • Useful ffmpeg commands

Archives

  • April 2022
  • March 2022
  • January 2022
  • December 2021
  • November 2021
  • September 2021
  • June 2021
  • April 2021
  • October 2020
  • April 2020
  • March 2020
  • February 2020
  • January 2020
  • October 2019
  • August 2019
  • July 2019
  • March 2019
  • October 2018
  • August 2018
  • July 2018
  • March 2018
  • February 2018
  • September 2017
  • August 2017
  • May 2017
  • April 2017
  • November 2016
  • September 2016
  • July 2016
  • June 2016
  • May 2016
  • April 2016
  • March 2016
  • January 2016
  • December 2015
  • October 2015
  • September 2015
  • August 2015
  • July 2015
  • February 2015

Categories

  • 3D Printing
  • Active Directory
  • Apple
  • Backup
  • Browser
  • Bugzilla
  • Docker
  • Electronics
  • LANCOM
  • Linux
  • Microcontroller
  • Microsoft Office
  • MikroTik
  • Misc
  • Networking
  • OS X
  • Other
  • pfSense
  • Sophos
  • SSL
  • Synology
  • VMware
  • Webdevelopment
  • Windows
  • Home
  • Imprint
$bLOG Proudly powered by WordPress