SQL tutorial-Update data

Update data

To update data in a table using SQL, you need to use the UPDATE statement. The followings you also should bear in mind before updating data to a table or multiple tables of database:
-If the data type of the fields that you want to insert data are text/string and date/time, the data values to be inserted need to put single quotes('').
-If the data type of the fields that you want to insert data are number you don't  need to put the data values to be inserted in single quote('').
-The data values to be inserted need to have the same data type as the fields that you want to insert data to.
The UPDATE statement has the following syntax:

UPDATE Table-name
SET field-name1=val1, field-name2=val2,...)

[WHERE...];

Example: Changing the sex of student with id of S001 from F to M.

TblStudent table:

UPDATE TblStudent

SET Sex='M'

WHERE StuID='S001';

Note: Without WHERE clause, you will update all rows of the field Sex.