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:

StuID StuName Sex DOB Address Tel
S001Sao VirakF 12-02-1982 #234, st. 230, Phnom Penh 0897654678
S002Sok LidaM 03-06-1984 Chambak Bati Tramkna 092767896
S003Cheng SokunF 09-09-1987 Mokkampoul, Kandal 090543123

UPDATE TblStudent

SET Sex='M'

WHERE StuID='S001';

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




Comments

KrishnaMohan comment

 KrishnaMohan

Check this also for sql interview quetions http://skillgun.com/sql/interview-questions-and-answers

09-02-2014
Name:
Comment:
Enter the text:
CAPTCHA image

.........................................................................................................................Home | Forum | About | Contact
This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:
C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word.
However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.
Copyright @ 2011-2013 worldbestlearningcenter. All Rights Reserved.
Home Programming Web DB & App Questions Exercises Tips Programs FAQs Download About
Computer-Wbest
Popular Pages
You might like