Interested to Buy Any Domain ? << Click Here >> for more details...
what is DDL and DML?
- 10 Answers
- 29794 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / siva
Data Definition Language - DDL
Data Manipulation Language - DML
| Is This Answer Correct ? | 61 Yes | 2 No |
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).
| Is This Answer Correct ? | 46 Yes | 2 No |
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 ;-)
| Is This Answer Correct ? | 20 Yes | 3 No |
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>;
| Is This Answer Correct ? | 16 Yes | 2 No |
Answer / harry
ddl: means data definition langauge
dml: means data manipulation language
ddl: select, alter, drop
dml: insert update delte
| Is This Answer Correct ? | 12 Yes | 8 No |
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.
| Is This Answer Correct ? | 2 Yes | 0 No |
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
| Is This Answer Correct ? | 1 Yes | 0 No |
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)
| Is This Answer Correct ? | 1 Yes | 0 No |
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.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / ramavtar rajput
Ddl auto cmit hota hai mens not roll back
Dml auto comit nahi hota hai means roll back ho sakta hai
| Is This Answer Correct ? | 8 Yes | 11 No |
Is php a dying language?
Difference between mysql_connect and mysql_pconnect in php?
What is the use of get and post method in php?
What is htaccess? Why do we use this and where?
please explain me mail function in php
What is the use of php and mysql?
What is the main function of php?
what are the basic steps to installation php4+mysql4+phpmyadmin on IIS web server?. Pls write the complete steps.
Which parts of php are case sensitive?
iam mca post graduate in 2010 not getting job in JAVA so iam looking for carear in php as market demand is high so it is best option to try for php or not
Explain the difference b/w static and dynamic websites?
How does php session work?
PHP 
