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:
SET field-name1=val1, field-name2=val2,...)
Example: Changing the sex of student with id of S001 from F to M.
||#234, st. 230, Phnom Penh
||Chambak Bati Tramkna
Note: Without WHERE clause, you will update all rows of the field Sex.