What is SQL

What is SQL - SQL stands for Structured Query Language. SQL or also often referred to as a query is a language used to access the database. SQL was first introduced in IBM in 1970 and an ISO and ANSII standard is set for SQL. This standard does not depend on the machine used (IBM, Microsoft or Oracle). Almost all database software knows or understands SQL. So, the SQL command on all database software is almost the same.

What is SQL

There are 2 (two) types of SQL commands, namely:
1. DDL or Data Definition Language
DDL is a SQL command that deals with defining a database structure, in this case the database and table. Some basic commands that include DDL include:

• CREATE
• ALTER
• RENAME
• DROP

2. DML or Data Manipulation Language
DML is a SQL command that deals with manipulation or processing of data or records in a table. The SQL commands included in the DML include:

• SELECT
• INSERT
• UPDATE
• DELETE

Now we already know what is SQL. Hopefully the above article can increase our knowledge in learning sql command in the database. Thank you for visiting his blog php programming language. Also read article about: Tools MySQL Client for Administration.