Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How to update alternative columns in a database by using single update query?

user-image
Question added by Mukhtiar Shaikh , Software Implementation Support Engineer Fintech , TPS
Date Posted: 2017/05/27
Hadeel Jazzaa
by Hadeel Jazzaa , Lecturer , University of Huddersfield

Use the alternative column-list syntax to do  update. for Example:

 

UPDATE weather SET (temp_lo, temp_hi, prcp) = (temp_lo+1, temp_lo+15, DEFAULT)

  WHERE city = 'Baghdad' AND date = '2003-07-03';

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.