UPDATE
UPDATE statement is used to update the existing records in a table in SQL.
Syntax-
UPDATE <table_name>
SET column1 = value1, column2 = value2, …
WHERE <condition>;
Example-
UPDATE mstudentsnew
SET st_name = ‘Ajai’
WHERE st_id = 1;
Note- IF WHERE Clause is not used it will update all the records.