I am sharing some news about SQL . SQL is a database related language that is used to communicate with database. SQL stands for Structured Query Language which is the American National Standards Institute (ANSI) standard language for operating relational databases. SQL language have some statements that is used to data retrieves, new row entry, changes etc.
Now I am showing example of SQL Statements below:
1/ Data Manipulation Language (DML)
===============================
SELECT
INSERT
UPDATE
DELETE
MERGE
Basically data manipulation language is used to manipulate data from database. Changes existing rows, removes unwanted rows, retrieves data by using DML statement.
2/ Data Definition Language (DDL)
===========================
CREATE
ALTER
DROP
TRUNCATE
COMMENT
Data Definition Language is used to changes, sets up, removes data structures from tables.
3/ Data Control Language (DCL)
=========================
GRANT
REVOKE
Basically it’s used to give and take power for data access from database. User or Administrator can give power their client to access database by using above DCL statement.
4/ Transaction control
==================
COMMIT
ROLLBACK
SAVEPOINT
We can change database by using Data Manipulation Language or DML statement, after changing its control by using above statement.
SQL language is a server support language that is used to communicate with the database server to access, manipulate and control data.