Bayt.com

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?

Databases Queries Data Administration Database
user-image
Question added by Mukhtiar Shaikh , Software Implementation Support Engineer Fintech , TPS
Date Posted: 2017/05/27
Upvote (0) Views (8) Followers (1) Answers (1) Report Question
Write an Answer
Register now or log in to answer.
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';

Write Your Answer
More Questions Like This