SQL

Page 1

Queries

SELECT - gets data from a database

INSERT - add a record to a table

UPDATE - change existing data

DELETE - remove records

SELECT

SELECT <fields>

FROM <table>

WHERE <condition>

ORDER BY <fields>

DELETE

DELETE

FROM <table>

WHERE <condition>

Page 2

UPDATE

UPDATE <table>

SET <field>=<value>[,<f2>=<v2>…]

WHERE <condition>

INSERT

INSERT

INTO <table> [(<f1>,<f2>…)]

VALUES (<v1>[,<v2>,<v3>…])

CREATE TABLE

CREATE TABLE tbl_Customers

(

cust_id int Primary Key,

name varchar(30),

age int,

Address varchar(100)

)

Page 3