What will happen if we forget to write where clause to update table in sql queries? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 15

What will happen if we forget to write where clause to update table in sql queries?

Suppose in a table Employee I want to update employee's name but we forgot to write where clause.

15th Feb 2018, 8:23 PM
A͢J
A͢J - avatar
5 Answers
+ 1
It's gonna change all name in column to specified one.😂😂
15th Feb 2018, 8:50 PM
Akib
Akib - avatar
+ 1
it will update all employees name with same name
16th Feb 2018, 3:54 AM
manish singh
manish singh - avatar
+ 1
If this happens on mission critical database you'll probably get fired ;-)
19th Feb 2018, 2:12 PM
Natalia
Natalia - avatar
+ 1
The column of table employee will have same names. Every row will get updated with the changes
6th Mar 2019, 9:50 AM
Adhit Narayanan
Adhit Narayanan - avatar
0
Ofcourse it will update all the name in table
10th Oct 2019, 3:58 AM
Sanjay Tiwari
Sanjay Tiwari - avatar