DDL: Data Definition Language as the name suggest, these are
used to define the database schema. These
commands do not deal with the data, rather the structure. Some DDL commands are
- CREATE
- ALTER
- DROP
- TRUNCATE
- RENAME
DML: Data Manipulation Language are used to manipulate data. These are used for populating data into and retrieve from database. They use condition clauses like where, if along with operators ( like arithmetic, comparison, logical etc) and joins to specify conditions to fetch the required data from the appropriate table, column and row, from the database structure. These commands deal with data directly from insertion, updating and deletion. Some DDL commands are
- SELECT
- INSERT
- UPDATE
- DELETE
Happy SQLing!
Please post your comments (+ve or -ve, even neutral 😅 )and questions and feel free share
it to with your friends .
Cos sharing is caring..! 😎
Until next blog,
Vino BI Dev
No comments:
Post a Comment