SQL Definition

SQL stands for Structured Query Language. SQL or also

often referred to as a query language (language)

used to access the database. SQL was first introduced in IBM

in 1970 and an ISO standard and ANSII set to SQL.

This standard does not depend on the engine used (IBM, Microsoft or

Oracle). Almost all software know or understand SQL database. So,

SQL command on all database software is almost the same.

There are two (2) types of SQL commands, namely:

1. DDL or Data Definition Language

DDL is the SQL command associated with the definition of a

the database structure, in this case the database and table. Some basic commands

DDL that includes, among others:

CREATE

ALTER

RENAME

DROP

2. DML or Data Manipulation Language

DML a SQL command associated with manipulation or

data processing or records in a table. SQL commands that are included in

DML among others:

SELECT

INSERT

UPDATE

DELETE

Tweet

Artikel keren lainnya:

Ditulis oleh kata-quotes pada tanggal Saturday, September 5, 2015