In the following MySQL command how many rows will be updated? UPDATE person SET lname=’s’, Fname=’p’, WHERE person_id<10; /* person_id is a primary key */

Q. In the following MySQL command how many rows will be updated?
UPDATE person
SET lname=’s’,
Fname=’p’,
WHERE person_id<10;
/* person_id is a primary key */

(A) 0-9
(B) 1-6
(C) No row
(D) None of the mentioned

✅ Correct Answer: (A) 0-9

Explanation: This question is asking about the number of rows that will be updated in a MySQL database using the provided command. Let's break it down:

Published by Praveen Singh ⭐ 36.81K Points at 22-Mar-2025 12:43 pm in MySQL

Explanation by: Praveen Singh

This question is asking about the number of rows that will be updated in a MySQL database using the provided command. Let's break it down:

💬 Discussion

📊 Question Analytics

👁️

108

Total Visits

📽️

1 y ago

Published

🎖️

Praveen Singh

Publisher

📈

91%

Success Rate

Q. In the following MySQL command how many rows will be updated? UPDATE person SET lname=’s’, Fname=’p’, WHERE person_id<10; /* person_id is a primary key */

Explanation by: Praveen Singh

💬 Discussion

📊 Question Analytics

Q. In the following MySQL command how many rows will be updated?
UPDATE person
SET lname=’s’,
Fname=’p’,
WHERE person_id<10;
/* person_id is a primary key */