Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

what is DDL and DML?

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


Please Help Members By Posting Answers For Below Questions

Can you define an argument as a reference type?

962


How to track user logged out or not? When user is idle?

964


What are the different types of php variables?

1055


How to enable parsing?

1070


Explain what does the function get_magic_quotes_gpc() means?

931


How can I use single quotes in single quotes in php?

880


Which Scripting Engine PHP uses?

1179


Tell me what is the actually used php version?

1028


What does the php error 'parse error in php - unexpected t_variable at line x' means?

1102


What are the uses of explode() and implode() functions?

1111


Write a program in php to reverse a number?

999


What is use of header() function in php?

1029


What is overloading in php?

999


Can you explain, when to use if-else if-else over switch statements?

1013


Which is the latest version of php?

1111