Forum discussion on MySQL

Answer the question and discuss

Answer the question and discuss

by Md Assaduzzaman -
Number of replies: 24

1. What are the difference between DDL and DML

In reply to Md Assaduzzaman

Re: Answer the question and discuss

by Md Ahsan Habib -
Key Differences between DDL and DML Commands:
The following points explain the main differences between DDL and DML commands:

  1. Data Definition Language (DDL) statements describe the structure of a database or schema. Data Manipulation Language (DML) statements, on the other hand, allow altering data that already exists in the database.
  2. We use the DDL commands for creating the database or schema, while DML commands are used to populate and manipulate the database.
  3. DDL commands can affect the whole database or table, whereas DML statements only affect single or multiple rows based on the condition specified in a query.
  4. Since DDL commands are auto-committed, modifications are permanent and cannot be reversed. DML statements, on the other hand, are not auto-committed, which means that modifications are not permanent and can be reversed.
  5. DML is an imperative and procedural method, whereas DDL is a declarative method.
  6. The data in DML statements can be filtered with a WHERE clause, while the records in DDL statements cannot be filtered with a WHERE clause.
In reply to Md Assaduzzaman

Re: Answer the question and discuss

by Jannatul Marjan -
DDL stands for Data Definition Language. DML stands for Data Manipulation Language. DDL statements are used to create database, schema, constraints, users, tables etc. DML statement is used to insert, update or delete the records
In reply to Md Assaduzzaman

Re: Answer the question and discuss

by A. B. M. Mohiuddin -

Answer to the Question no-1

DDL

DDL is Data Definition Language and is used to define the structures like schema, database, tables, constraints etc. Examples of DDL are create and alter statements.

DML

DML is Data Manipulation Language and is used to manipulate data. Examples of DML are insert, update and delete statements.


In reply to Md Assaduzzaman

Re: Answer the question and discuss

by Nahidul islam Nihal -
DDL:
Data Definition Language helps you to define the database structure or schema. DDL commands help you to create the structure of the database and the other database objects. Its commands are auto-committed so, the changes are saved in the database permanently. The full form of DDL is Data Definition Language.
DML:
DML commands it to allow you to manage the data stored in the database, although DML commands are not auto-committed. Moreover, they are not permanent. So, It is possible to roll back the operation. The full form of DML is Data Manipulation Language.
In reply to Md Assaduzzaman

Re: Answer the question and discuss

by Sohana Tasmim -
Here is the difference between DDL and DML:
DDL-
*DDL(Data Definition Language) helps you to define the database structure or schema.
* DDL commands help you to create the structure of the database and the other database objects.
*Its commands are auto-committed so, the changes are saved in the database permanently.
DML-
*DML(Data Manipulation Language) commands it to allow you to manage the data stored in the database.
*DML commands are not auto-committed. Moreover, they are not permanent.
In reply to Md Assaduzzaman

Re: Answer the question and discuss

by Md Rifat Rahman -
DDL
DDL is Data Definition Language and is used to define the structures like schema, database, tables, constraints etc. Examples of DDL are create and alter statements.

DML
DML is Data Manipulation Language and is used to manipulate data. Examples of DML are insert, update and delete statements.
In reply to Md Assaduzzaman

Re: Answer the question and discuss

by Abdul Hadi Hemal -
Differences:
1.
Data Definition Language (DDL) is a type of SQL command that helps to define the schema of the Database.
Data Manipulation Language (DML) is a type of SQL command that helps to retrieve and manage data in relational databases.
2.
DDL statements are used to create database, schema, constraints, users, tables etc.
DML statement is used to insert, update or delete the records.
3.
While using the DDL statements, the changes made by them cannot be rolled back. So there is need to run COMMIT or ROLLBACK.
In DML, statements, the COMMIT and ROLLBACK commands should be run to confirm the changes.
In reply to Md Assaduzzaman

Re: Answer the question and discuss

by Anaminni Akbar Rupa -
DDL stands for Data Definition Language and DML stands for Data Manipulation Language.
DDL statements are used to create database, schema, constraints, users, tables etc.And DML statement is used to insert, update or delete the records
In reply to Md Assaduzzaman

Re: Answer the question and discuss

by Md.Iftakher Alam -
DDL:
Data Definition Language helps you to define the database structure or schema. DDL commands help you to create the structure of the database and the other database objects. Its commands are auto-committed so, the changes are saved in the database permanently. The full form of DDL is Data Definition Language.
DML:
DML is Data Manipulation Language and is used to manipulate data. Examples of DML are insert, update and delete statements.
In reply to Md Assaduzzaman

Re: Answer the question and discuss

by Md. Sarowal -
DDL:
Data Definition Language helps you to define the database structure or schema. DDL commands help you to create the structure of the database and the other database objects. Its commands are auto-committed so, the changes are saved in the database permanently. The full form of DDL is Data Definition Language.
DML:
DML commands it to allow you to manage the data stored in the database, although DML commands are not auto-committed. Moreover, they are not permanent. So, It is possible to roll back the operation. The full form of DML is Data Manipulation Language.
In reply to Md Assaduzzaman

Re: Answer the question and discuss

by Mehedi Hasan -
DDL:
Data Definition Language helps you to define the database structure or schema. DDL commands help you to create the structure of the database and the other database objects. Its commands are auto-committed so, the changes are saved in the database permanently. The full form of DDL is Data Definition Language.
DML:
DML is Data Manipulation Language and is used to manipulate data. Examples of DML are insert, update and delete statements.
In reply to Md Assaduzzaman

Re: Answer the question and discuss

by Khandoker Shamimul Haque -
DDL:
Data Definition Language (DDL) statements are used to define the database structure or schema. 
Following are DDL statements:

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


DML:
Data Manipulation Language (DML) statements are used for managing data within schema objects. 
Following are DML statements:

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
In reply to Md Assaduzzaman

Re: Answer the question and discuss

by Rakibul Hasan -
DDL:
Data Definition Language helps you to define the database structure or schema. DDL commands help you to create the structure of the database and the other database objects. Its commands are auto-committed so, the changes are saved in the database permanently. The full form of DDL is Data Definition Language.
DML:
DML commands it to allow you to manage the data stored in the database, although DML commands are not auto-committed. Moreover, they are not permanent. So, It is possible to roll back the operation. The full form of DML is Data Manipulation language.
In reply to Md Assaduzzaman

Re: Answer the question and discuss

by Md. Monirul Islam -
DDL: Data Definition Language helps you to define the database structure or schema. DDL commands help you to create the structure of the database and the other database objects. Its commands are auto-committed so, the changes are saved in the database permanently. The full form of DDL is Data Definition Language.
DML: DML commands it to allow you to manage the data stored in the database, although DML commands are not auto-committed. Moreover, they are not permanent. So, It is possible to roll back the operation. The full form of DML is Data Manipulation Language.
In reply to Md Assaduzzaman

Re: Answer the question and discuss

by Raihan Islam Sonet_181-15-1983 -

Difference between DDL and DML:

DDL: 

DDL stands for Data Definition Language. DDL statements are used to create database, schema, constraints, users, tables etc.

DML:

DML stands for Data Manipulation Language. DML statement is used to insert, update or delete the records.


In reply to Md Assaduzzaman

Re: Answer the question and discuss

by Md Golam Rabbani -
(a) Data Definition Language (DDL) statements describe the structure of a database or schema. Data Manipulation Language (DML) statements, on the other hand, allow altering data that already exists in the database.
(b) We use the DDL commands for creating the database or schema, while DML commands are used to populate and manipulate the database.
DDL commands can affect the whole database or table, whereas DML statements only affect single or multiple rows based on the condition specified in a query.
(c) Since DDL commands are auto-committed, modifications are permanent and cannot be reversed. DML statements, on the other hand, are not auto-committed, which means that modifications are not permanent and can be reversed.
In reply to Md Assaduzzaman

Re: Answer the question and discuss

by Md Imran Hossan -
DDL
DDL is Data Definition Language and is used to define the structures like schema, database, tables, constraints etc. Examples of DDL are create and alter statements.

DML
DML is Data Manipulation Language and is used to manipulate data. Examples of DML are insert, update and delete statements.
In reply to Md Assaduzzaman

Re: Answer the question and discuss

by Md Hasibul Hassan -
Data Definition Language helps you to define the database structure or schema. DDL commands help you to create the structure of the database and the other database objects. Its commands are auto-committed so, the changes are saved in the database permanently. The full form of DDL is Data Definition Language.
DML:
DML commands it to allow you to manage the data stored in the database, although DML commands are not auto-committed. Moreover, they are not permanent. So, It is possible to roll back the operation. The full form of DML is Data Manipulation Language.
In reply to Md Assaduzzaman

Re: Answer the question and discuss

by Rasel Hossain -
DDL
1.DDL stands for Data Definition Language.
2.DDL statements are used to create database, schema, constraints, users, tables etc.
3.CREATE, DROP, RENAME and ALTER.

DML
1.DML stands for Data Manipulation Language.
2.DML statement is used to insert, update or delete the records.
3.INSERT, UPDATE and DELETE.
In reply to Md Assaduzzaman

Re: Answer the question and discuss

by Shahariar hasan Shadhin -

DDL:
Data Definition Language helps you to define the database structure or schema. DDL commands help you to create the structure of the database and the other database objects. Its commands are auto-committed so, the changes are saved in the database permanently. The full form of DDL is Data Definition Language.
DML:
DML commands it to allow you to manage the data stored in the database, although DML commands are not auto-committed. Moreover, they are not permanent. So, It is possible to roll back the operation. The full form of DML is Data Manipulation Language.

In reply to Md Assaduzzaman

Re: Answer the question and discuss

by Sharmila zaman -
DDL is an abbreviation of Data Definition Language. It is used to create and modify the structure of database objects in the database. In comparison, DCL is an abbreviation of Data Control Language. It is used to create roles, permissions, and referential integrity as well it is used to control access to a database by securing it.
In reply to Md Assaduzzaman

Re: Answer the question and discuss

by Tanjir rahman -
DDL:
Data Definition Language helps you to define the database structure or schema. DDL commands help you to create the structure of the database and the other database objects. Its commands are auto-committed so, the changes are saved in the database permanently. The full form of DDL is Data Definition Language.
DML:
DML commands it to allow you to manage the data stored in the database, although DML commands are not auto-committed. Moreover, they are not permanent. So, It is possible to roll back the operation. The full form of DML is Data Manipulation Language.
In reply to Md Assaduzzaman

Re: Answer the question and discuss

by Anisuzzaman Shayak 181-15-1988 -
DDL stands for Data Definition Language.
DML stands for Data Manipulation Language.

DDL statements are used to create database, schema, constraints, users, tables etc.
DML statement is used to insert, update or delete the records
In reply to Md Assaduzzaman

Re: Answer the question and discuss

by Rashaduzzaman Ananda 181-15-1870 -
DDL
DDL is Data Definition Language and is used to define the structures like schema, database, tables, constraints etc. Examples of DDL are create and alter statements.

DML
DML is Data Manipulation Language and is used to manipulate data. Examples of DML are insert, update and delete statements.