Sql Update Query Without Where Condition

In this statement, it will set the department_name to ‘FresherBell India’, manager_id to 425, and location_id to 2000 of all the records in the table departments.

If we do not include the where condition in the statement. Then it will update all the records of the departments' table.

Enter - Select * from table_name;
SQL Query
UPDATE departments SET department_name = 'FresherBell India', manager_id = 425, location_id = 2000; SELECT * FROM departments;