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
- 7566 Views
- I also Faced
- E-Mail Answers
Answer Posted / tulsi
1)With commas (SET price = 0, status = 'I')
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
what is innodb? : Sql dba
How can you know that statistics should be updated?
What are the advantages of indexing?
What are the advantages of pl sql over sql?
What is difference between rank () row_number () and dense_rank () in sql?
Are sql connections encrypted?
Which command is used to call a stored procedure?
what are the advantages of sql ? : Sql dba
Define commit, rollback and savepoint?
What type of join is sql join?
discuss about myisam key cache. : Sql dba
Describe types of sql statements?
What is the requirement of self-join?
Can a varchar be a primary key?
What is scalar function?
