DDL--Data Definition Language
and Commands for DDL as:
1.CREATE DATABASE--create a new data base
2.ALTER DATABASE---modifies a database
3.CREATE TABLE---create a new table
4.ALTER TABLE---modifies a table
5.DROP TABLE---deletes a table
6.CREATE INDEX---creates an index(search key)
7.DROP INDEX---deletes an index
DML---Data Manipulation Language
Commands from the DML part of SQL:
1.SELECT----extracts data from a database
2.UPDATE--updates data in a database
3.DELETE---deletes data from a database
4.INSERT INTO---insert new data into a database
The basic difference between DDL and DML is the commands they provide . The dml (data manipulation language) provides statements to enter, update, delete and perform complex queries on these tables while the ddl(data description language) provides statement for the creation and deletion of tables, indexes, views etc.
The basic difference between DDL and DML is the commands they provide . The DDL provides statement for the creation and deletion of tables, indexes, views etc. while the DML provides statements to enter, update, delete and perform complex queries on these tables.
The differences between them you can get from, http://arjudba.blogspot.com/2008/04/what-are-difference-between-ddl-dml-and.html
The DDL provides statement for the creation and deletion of tables, indexes, views etc. The DML provides statements to enter, update, delete and perform complex queries on these tables.
DML
ddl: data definition languagedml: data manipulation language
Details is discussed on http://arjudba.blogspot.com/2008/04/what-are-difference-between-ddl-dml-and.html
To put information into a database, you typically need to use a database management system (DBMS) such as MySQL, Oracle, or MongoDB. You would write SQL queries to insert data into specific tables within the database by specifying the values you want to store in each column. This process allows you to organize and store data efficiently for future retrieval and analysis.
DML(data manipulation language) provides statements to enter, update, delete and perform complex queries on these tables. DDL(Data definition language) provides statements for creation and deletion of tables, view, indexes etc.
Data Definition Lenguage (DDL) Data Manipulation Lenguage (DML) Data Dictionary
Retrieving Data,Inserting Data,and Deleting Data.
The three languages adopted by the DBTG (Data Base Task Group) were ALPHA, BETA, and GAMMA. ALPHA was intended for simple, stand-alone database queries, BETA was designed for more complex queries involving multiple files, and GAMMA was meant for defining the structure of a database schema.