Sql Query To Update Multiple Column

In this statement, it will set the department_name to ‘FresherBell India’, manager_id to 425, and location_id to 2000 of table departments, whose departmnet_id is 20.

This Statement is only used for multiple columns.

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