Home / code / sql

SQL,Structured Query Language

Structured Query Language is a language that is used to communicated with databases. Both ASP and CGI use it.
The actual management of the data is done by Relational DataBase Management System(RDBMS). With SQL we give orders to RDBMS.
There are 3 categories of SQL instructions: Data Manipulation Language (DML), Data Definition Language (DDL) and Data Control Language (DCL).

DML is used to select, add, change and delete contents of the database

DDL creates and manage databases, tables, views and indexes.

DCL is used to secure the database. Everyone may read, but only some persons can change the data.



Latest script: