> > >

MySQL MCQs

Which of the following is the best way to update multiple rows? Example: Name id Col1 Col2 name1 1 6 1 name2 2 2 3 name3 3 9 5 name4 4 16 8 Update Col1= 1 where id = 1 Update Col1= 2 where id = 2 Update Col2= 3 where id = 3 Update Col1= 10 and col2= 12 where id = 4

UPDATE table_name SET Col1 = CASE id WHEN 1 THEN 1 WHEN 2 THEN 2 WHEN 4 THEN 10 ELSE Col1 END, Col2 = CASE id WHEN 3 THEN 3 WHEN 4 THEN 12 ELSE Col2 END WHERE id IN (1, 2, 3, 4);

UPDATE table_name SET Col1 = 1 WHERE id = 1; UPDATE table_name SET Col1 = 2 WHERE id = 2; UPDATE table_name SET Col2 = 3 WHERE id = 3; UPDATE table_name SET Col1 = 10 WHERE id = 4; UPDATE table_name SET Col2 = 12 WHERE id = 4;

INSERT INTO table_name (id,Col1,Col2) VALUES (1,1,1),(2,2,3),(3,9,3),(4,10,12) ON DUPLICATE KEY UPDATE Col1=VALUES(Col1),Col2=VALUES(Col2);

UPDATE table_name SET col1 = '1' WHERE id IN (1); UPDATE table_name SET col1 = '2' WHERE id IN (2); UPDATE table_name SET col2 = '3' WHERE id IN (3); UPDATE table_name SET col1 = '10', col2='12' WHERE id IN (4);

Answer

Correct Answer: INSERT INTO table_name (id,Col1,Col2) VALUES (1,1,1),(2,2,3),(3,9,3),(4,10,12) ON DUPLICATE KEY UPDATE Col1=VALUES(Col1),Col2=VALUES(Col2);

Explanation:

Note: This Question is unanswered, help us to find answer for this one

MySQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it