J

Jatin Dubey • 3.78K Points
Extraordinary 

Q. Is it important to provide where condition with update statement in MYSQL?

  • (A) Yes
  • (B) No
  • (C) ---
  • (D) ---
  • Correct Answer - Option(A)
  • Views: 128
  • Filed under category MySQL
Explanation by: Jatin Dubey 
YES it is important to provide the where condition with an update statement else the entire column will have the same updated value.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.

Related MCQs on MySQL

Q. Which of the following statements is/are correct?

Q. The operator used in PHP to access property of an object is . . . . . . . .

Q. What is xyz in the following MySQL statement? SELECT * FROM my_table WHERE MATCH(abc) AGAINST('xyz');

Q. The size of the BIT type is _____ ?

Q. The MySQL server is highly configurable.

Q. To see the table structure which command is issued?

Q. What is the significance of the statement "HAVING COUNT (emp_id)>2" in the following MySQL statement? SELECT d.name, COUNT (emp_id) emp_no FROM department d INNER JOIN Employee e ON d.dept_id=e.emp_id GROUP BY d.name HAVING COUNT (emp_id)>2

Q. What does RTF refer to?

Q. What is defined to execute when the table is modified only?

Q. The join in which all the rows from the right table appear in the output irrespective of the content of the other table is

Learn All MySQL MCQs

Question analytics