Oracle
1Z0-882 · Question #78
A MySQL command- line client is started with safe updates disabled. Mysql - -safe - updates=0 What happens when you execute an UPDATE statement without a WHERE clause?
The correct answer is B. Updates every row in the specified table(s). to-update-a-table-without-a-where-that-uses-a-key-column/
SQL Data Manipulation
Question
A MySQL command- line client is started with safe updates disabled. Mysql - -safe - updates=0 What happens when you execute an UPDATE statement without a WHERE clause?
Options
- AResults in an error
- BUpdates every row in the specified table(s)
- CResults in - -safe-updates being enabled automatically
- DCauses a syntax error
How the community answered
(24 responses)- A4% (1)
- B79% (19)
- C4% (1)
- D13% (3)
Explanation
to-update-a-table-without-a-where-that-uses-a-key-column/
Topics
#UPDATE statement#safe-updates#WHERE clause#DML
Community Discussion
No community discussion yet for this question.