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.
|S001||Sao Virak||F||12-02-1982||#234, st. 230, Phnom Penh||0897654678|
|S002||Sok Lida||M||03-06-1984||Chambak Bati Tramkna||092767896|
|S003||Cheng Sokun||F||09-09-1987||Mokkampoul, Kandal||090543123|
Note: Without WHERE clause, you will update all rows of the field Sex.
This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages: