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
Can you define an argument as a reference type?
How to track user logged out or not? When user is idle?
What are the different types of php variables?
How to enable parsing?
Explain what does the function get_magic_quotes_gpc() means?
How can I use single quotes in single quotes in php?
Which Scripting Engine PHP uses?
Tell me what is the actually used php version?
What does the php error 'parse error in php - unexpected t_variable at line x' means?
What are the uses of explode() and implode() functions?
Write a program in php to reverse a number?
What is use of header() function in php?
What is overloading in php?
Can you explain, when to use if-else if-else over switch statements?
Which is the latest version of php?