SQL

Structured Query Language

HideShow resource information

DDL - Data Definition Language

CREATE DATABASE


CREATE USER


CREATE TABLE


DROP - Deletes a table, database or user

GRANT - Grants access/privalages to users

1 of 2

DML - Data Manipulation Language

  • INSERT INTO - Makes a new row in the table and adds the values suppplied in

E.g. INSERT INTO Customer (CustomerID, Email Address)

VALUES ('ABC1', [email protected]')

  • UPDATE - Changes values in a table using a calculation

E.g. UPDATE Item

SET (UnitPrice * 2)

  • DELETE - Deletes a row in a table

E.g. DELETE ItemPrice FROM Item

2 of 2

Comments

No comments have yet been made

Similar Computing resources:

See all Computing resources »See all resources »