SQL Video Tutorial: How to use UPDATE Sql statement

UPDATE statement is one of common DML (data manipulation language) statements. Other DML statements include:

1. SELECT
2. INSERT
3. DELETE

UPDATE query is used to update or modify data in a Table or a View in a database. Using this statement, you can update a single field, multiple fields, single record or multiple records. Need to use WHERE clause to limit affected rows. Without the WHERE clause, you will update all the rows in a table! Ooops! UPDATE query can also use a sub-select aka sub query. More…