Modifying Record: SQL provides us with modifying and updating the existing records in a table using UPDATE command. The age of Krishna in Biodata table is changed using the below Syntax.
Syntax: UPDATE tablename SET column1= “new value” Where column2= “value2”; Example: mysql>UPDATE Biodata SET age=13 WHERE firstname= “Krishna”;