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
How to set session.gc_divisor properly?
What are php magic quotes?
Where is the functions php in wordpress?
Do you know design patterns. List few?
Is php a mvc?
What is composer used for?
What is the php function that removes the first element of the array and returns it?
What are the data types in php?
What is the phpstorm?
What is singleton design pattern in php?
What is variable declaration?
What is difference between count or sizeof function in php?
How is traits used in php?
How to pass variables and data from php to javascript?
write a prog using insert,update,delete in this manner as output? name: phno. add button 1.name phno. edit button delete button 2.
