Answer / siva

Data Definition Language - DDL

Data Manipulation Language - DML

Answer / akshaya

DDL, DML and DCL are types of SQL commands
DDL: Data Definition Language.
DML: Data Manipulation Language.
DCL: Data Control Language.

DDL is used to CREATE, ALTER OR DROP the database objects
(Table, Views, Users).

DML is used to manipulate with the existing data in the
database objects.(insert, update, delete)

DCL is used to control the database transaction. Examples:
Grant and Revoke (In Oracle).

Answer / sagar_joshi

DDL => Data Definition Language
DML => Data Manipulation Language
i know only fullform plz send me a definition of DDl & DML
ok,

HAVE A NICE DAY ;-)

Answer / ambika balasubramanian

DDL => Data Definition Language
DML => Data Manipulation Language
DDL Commands
1. CREATE TABLE
2. ALTER TABLE
3.DESCRIBE TABLE
4.DROP TABLE
* CREATE TABLE
Syntax:
create table tablename( fieldname1 datatype(),fieldname2
datatype()...);
*ALTER TABLE
1. ADD
2.MODIFY
*ADD
Syntax:
alter table tablename ADD(fieldname datatype()...);
*modify:
syntax:
Alter table tablename modify(fieldname datatype()...);
*DESCRIBE TABLE
Syntax:
DESC(table name)
*DROP TABLE
Syntax: DROP TABLE(Table name);
DML Commands:
1.INSERT
2.SELECT
3.UPDATE
4.DELETE
*INSERT:
SYN:
INSERT INTO Tablename values();
*SELECT:
syn:
select*from <table name>
*UPDATE:
SYN:
update<table name> set to(calculation);
*DELETE:
SYN:
delete form<table name>;

Answer / harry

ddl: means data definition langauge
dml: means data manipulation language

ddl: select, alter, drop
dml: insert update delte

Answer / prakash patidar

DDL deal with structure of tables ,It means this is work on
create table and delete table.
ex- crate table, drop table.

DML deal with data in table. if we are used DML query it's
affected only data not on table structure.
ex- insert,update ,delete.

Answer / mobin mohan

Data Definition Language (DDL) statements are used to define the database structure or schema.
CREATE - to create objects in the database
ALTER - alters the structure of the database
DROP - delete objects from the database
TRUNCATE - remove all records from a table, including all spaces allocated for the records are removed
COMMENT - add comments to the data dictionary
RENAME - rename an object


Data Manipulation Language (DML) statements are used for managing data within schema objects.
SELECT - retrieve data from the a database
INSERT - insert data into a table
UPDATE - updates existing data within a table
DELETE - deletes all records from a table, the space for the records remain
MERGE - UPSERT operation (insert or update)
CALL - call a PL/SQL or Java subprogram
EXPLAIN PLAN - explain access path to data
LOCK TABLE - control concurrency


Data Control Language (DCL) statements.
GRANT - gives user's access privileges to database
REVOKE - withdraw access privileges given with the GRANT command

Answer / r.veeramanikandan

DDL----> Data definition Language is used to define the structure of database
DML-----> Data Manipuation Language is used the manage the data within the structure
DCL-----> Data Control Language is used to control the database. (grant priviledges to users)

Answer / 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.

Answer / ramavtar rajput

Ddl&#61664; auto cmit hota hai mens not roll back
Dml&#61664; auto comit nahi hota hai means roll back ho sakta hai

Which framework is best for php?

0 Answers  

Which is the best php framework for a beginner?

0 Answers  

How to remove the new line character from the end of a text line?

0 Answers  

How can we increase the execution time of a PHP script?

12 Answers   CyberBeoz, Photon, XTX,

Why do we use javascript in php?

0 Answers  

Whether php supports microsoft sql server?

0 Answers  

What and How possible injection in PHP and mysql?

3 Answers   RedAlkemi,

What are computer variables?

0 Answers  

Does php support multithreading?

0 Answers  

How can we send mail using JavaScript?

13 Answers   dwise, iScope,

What is difference between mysqli and mysql?

0 Answers  

Tell me how can we change the maximum size of the files to be uploaded?

0 Answers