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
What is session management php?
Can you use php and javascript together?
What is super keyword in php?
What is call by reference in php?
What is php built on?
What is the difference between get and post method in php?
Can php run on windows server?
How can we execute a php script using command line?
How to generate a form?
what is difference between PHP4 , PHP5
What is php regular expression?
Inside a php function, what param needs to be set in order to access a global variable?
What is the difference between php and core php?
What is self in php?
Suppose we receive a form submitted by a post to subscribe to a newsletter. This form has only one field, an input text field named email. How would we validate whether the field is empty? Print a message "the email cannot be empty" in this case?
