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')
- 2 Answers
- 7163 Views
- I also Faced
- E-Mail Answers
Answer Posted / roopa
with double-pipes (SET price=0 || status = 'I')
| Is This Answer Correct ? | 1 Yes | 9 No |
Post New Answer View All Answers
What is a table in a database?
Is sql similar to python?
What is minus?
What is sqlerrm?
What is not in sql?
What is synonyms?
What does pl sql stand for?
What is primary and foreign key?
what is the difference between group by and order by in sql? : Sql dba
How do you create an update query?
Can we use two order by clause in query?
Why we use joins in sql?
how many ways we can we find the current date using mysql? : Sql dba
What are joins in sql?
How do you take the union of two tables in sql?
