Question:Which of the following is the best way to insert a row, and to update an existing row, using a MySQL query? 

A Use MERGE statement 

B Use INSERT ... ON DUPLICATE KEY UPDATE statement 

C Use ADD UNIQUE statement 

D Use REPLACE statement 

+ Answer
+ Report
Total Preview: 1054

Copyright © 2024. Powered by Intellect Software Ltd