|
|
SQL Tutorial
The UPDATE statement
It is used to modify the data in a table.
Syntax
UPDATE table_name
SET column_name = new_value
WHERE column_name = Old_value
|
|
Example 6:
UPDATE Employee SET LastName = Potter,FirstName = 'HArry' WHERE
FirstName='John'
The Delete Statement
It is used to delete rows in a table.
Syntax
DELETE FROM table_name
WHERE column_name = some_value
|
Example 7:
DELETE FROM Employee WHERE FirstName = 'Steve';
Delete All Rows
DELETE FROM
table_name
or
DELETE * FROM table_name
Example 8:
DELETE FROM Employee;
or
DELETE FROM Employee;
Go To
Index
|
|
|
