over 4 years ago
<-- Chapter 18: SQL INSERT
UPDATE statement is used to update existing table data in database table with the help of WHERE clause.WHERE clause tells which record is to be updated.
Lets see an example from the below table "employees" :-
UPDATE SQL Statement Syntax :-
SET column1 = value1, column2 = value2, column3 = value3,,,
WHERE column = value;
UPDATE statement example :-
SET `salary` = 40000
WHERE employee_id = 102;
Now Run this Query, we will see the output below :-
We can see here, One existing record with Employee Id 102 is updated. salary column value for this record is updated to 40000 .
Chapter 20: SQL DELETE -->
Starting with Chrome version 45, NPAPI is no longer supported for Google Chrome. For more information, see Chrome and NPAPI (blog.chromium.org).
Firefox and Microsoft Internet Explorer are recommended browsers for websites using java applets.
Chrome Version Support
Are you sure, you want to delete this comment?
Terms of Service
| © copyright 2020 FindNerd.com. All rights reserved.
Sign up using