How are multiple column = value pairs delimited in the SET clause of an UPDATE

How are multiple column = value pairs delimited in the SET
clause of an UPDATE statement?

1. With commas (SET price = 0, status = 'I')
2. With parentheses (SET (price = 0) (status = 'I'))
3. With double-pipes (SET price = 0 || status = 'I')
4. With square-brackets (SET [price = 0] [status = 'I']
5. With single or multiple spaces (SET price = 0 status
= 'I')

Question Posted / suresh.chaluvadi

2 Answers
7129 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How are multiple column = value pairs delimited in the SET clause of an UPDATE statement? ..

Answer / tulsi

1)With commas (SET price = 0, status = 'I')

Is This Answer Correct ?

10 Yes

1 No

How are multiple column = value pairs delimited in the SET clause of an UPDATE statement? ..

Answer / roopa

with double-pipes (SET price=0 || status = 'I')

Is This Answer Correct ?

1 Yes

9 No

Post New Answer