Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / ankit
DDL (Data Definition Language) refers to the CREATE,
ALTER and DROP statements
DDL allows to add / modify / delete the logical structures
which contain the data or which allow users to access /
mantain the data (databases, tables, keys, views...). DDL is
about "metadata".
DML (Data Manipulation Language) refers to the INSERT,
UPDATE and DELETE statements
DML allows to add / modify / delete data itself.
DQL (Data Query Language) refers to the SELECT, SHOW and
HELP statements (queries)
SELECT is the main DQL instruction. It retrieves data you
need. SHOW retrieves infos about the metadata. HELP... is
for people who need help.
DCL (Data Control Language) refers to the GRANT and
REVOKE statements
DCL is used to grant / revoke permissions on databases and
their contents. DCL is simple, but MySQL's permissions are
rather complex. DCL is about security.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Which is better php or wordpress?
What is php crud api?
What is difference between explode() or split() in PHP?
Write a program in php to find the occurrence of a word in a string?
How is the comparison of objects done in php?
How to create an array in php?
What is csrf token and how will you add csrf token in ajax?
Is php used for frontend or backend?
What websites use php?
How can we check the value of a given variable is a number?
How many functions are there in php?
Is php used anymore?
Tell me how to get the value of current session id?
How to fix "headers already sent" error in php
Is jquery better than javascript?
