SQL syntax UPDATE statement

Question

I need to update DATA value in column "InstalDate" with current date for ID < 450 and update with DATE='2017-05-05' for the rest of table records and it need to be done in one command, so how to do it in one command?

I managed to do it but only for ID < 450 and don't know how to add second condition in one command.

UPDATE tabela SET InstalDate= NOW() WHERE ID<450;

ScaisEdge · Accepted Answer · 2017-06-11 16:17:47Z

1

could using a case in values to assign

UPDATE tabela 
SET InstalDate = case when ID <450 then  NOW() else '2017-05-05' end

answered Jun 11, 2017 at 16:17

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rtra · Accepted Answer · 2017-06-11 16:17:42Z

0

Adding conditions in UPDATE query is really simple you can simply use

UPDATE tabela SET InstalDate= NOW() WHERE ID<450 AND username='admin';

username='admin' is an example with an AND operator you change column name and its value

answered Jun 11, 2017 at 16:17

Rtra

52212 silver badges25 bronze badges

Comments

Akhil Saraswat · Accepted Answer · 2017-06-11 16:32:14Z

0

IF ID<450
    UPDATE tabela SET InstalDate= NOW()
ELSE
    UPDATE tabela SET InstalDate= '2017-05-05'

can you try this

answered Jun 11, 2017 at 16:32

Akhil Saraswat

841 silver badge10 bronze badges

Collectives™ on Stack Overflow

SQL syntax UPDATE statement

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related