Basic SQL Tutorial

SQL Language Tutorial
SQL Introduction
SQL Syntax
SQL Create Database
SQL Create Table (CREATE TABLE)
SQL Constraints (Constraints)
SQL Insert Data (INSERT INTO)
SQL Query Data (Select)
SQL WHERE
SQL AND & OR
SQL IN & BETWEEN
SQL ORDER By
SQL TOP/LIMIT
SQL DISTINCT
SQL Update Data (UPDATE)
SQL Delete Data (DELETE)
SQL Truncate Table (TRUNCATE TABLE)
SQL Drop Table (DROP)

SQL Connection (Join)

SQL Join Query (Join)
SQL INNER JOIN
SQL LEFT JOIN
SQL RIGHT JOIN
SQL FULL JOIN
SQL CROSS JOIN

Advanced SQL Tutorial

SQL UNION
SQL LIKE
SQL Alter Table (ALTER TABLE)
SQL Aliases (Aliases)
SQL GROUP BY
SQL HAVING
SQL Create View (CREATE VIEW)
SQL Create Index (CREATE INDEX)
SQL Date and Time
SQL Copy Table
SQL Temporary Table
SQL Subquery
SQL Injection (Injection)

SQL Reference Manual

MySQL Data Types
SQL Server Data Types
Comprehensive List of SQL Built-in Functions
SQL Keywords Quick Reference

SQL Keywords Quick Reference

Usage and examples of SQL UPDATE keyword

SQL Keywords Reference

UPDATE

The UPDATE command is used to update existing rows in the table.

The following SQL statement uses the new contactand New city to update the first customer (CustomerID = 1)

Example

　UPDATE Customers
　SET ContactName = 'Alfred Schmidt', City = 'Frankfurt';
　WHERE CustomerID =　1;

The following SQL statement will update the contact name to 'Juan' for all records with the country (region) 'Mexico':

Example

UPDATE Customers
SET ContactName = 'Juan';
WHERE Country = 'Mexico';

Note:Be careful when updating records in a table! Pay attention to the WHERE clause in the UPDATE statement. The WHERE clause specifies the records to be updated. If the WHERE clause is omitted, all records in the table will be updated!

SQL Keywords Reference

SQL Keywords Quick Reference