Sql Query To Update Single Record


In this statement, it will set the region_name to 'FresherBell India' of a table regions, whose region_id is 1.

This Statement is only used for a single record.

 

Enter - Select * from table_name;
SQL Query
UPDATE regions SET region_name = 'FresherBell India' WHERE region_id = '1'; SELECT * FROM regions;
Output