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 Join (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 SET keyword

SQL Keywords Reference

SET

The SET command is used with UPDATE to specify which columns and values should be updated in the table.

The following SQL uses a new contact name and a new city to update the first customer (CustomerID = 1) :

Example

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

For the 'Country/All records with the region 'Mexico' will have the field 'ContactName' updated to 'Juan':

Example

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

Note:Be careful when updating records in the table! Pay special attention to the UPDATE statement inWHERE clause. 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