2. SQL Commands | Commands in SQL | What is DDL Commands | What is DML commands | SQL tutorials
SQL Commands | Commands in SQL | What is DDL Commands | What is DML commands | SQL tutorials
Commands in SQL
What is DDL commands?
What is DML Commands?
Commands comes under DDL
Commands comes under DML
Join SQL WhatsApp group to solve your SQL queries:
https://chat.whatsapp.com/EkcHb9rAaP1...
SQL Commands:
1. DDL (Data Definition Language)
2. DML (Data Manipulation Language)
3. DCL (Data Control Language)
4. TCL (Transaction Control Language)
5. DQL (Data Query Language)
1. DDL (Data Definition Language)
CREATE, ALTER, DROP, TRUNCATE
DDL changes the structure of the table like creating a table, deleting a table, altering a table, etc.
All the command of DDL are auto-committed that means it permanently save all the changes in the database.
DDL does not use WHERE clause in its statement
2. DML (Data Manipulation Language)
INSERT, UPDATE, DELETE, MERGE
DML commands are used to modify the database. It is responsible for all form of changes in the database.
The command of DML is not auto-committed that means it can't permanently save all the changes in the database. They can be rollback.
DML uses WHERE clause in its statement.
3. DCL (Data Control Language)
GRANT, REVOKE
DCL commands are used to grant and take back authority from any database user.
4. TCL (Transaction Control Language)
COMMIT, ROLLBACK
TCL commands can only use with DML commands like INSERT, DELETE and UPDATE only.
These operations are automatically committed in the database that's why they cannot be used while creating tables or dropping them.
5. DQL (Data Query Language)
SELECT
DQL is used to fetch the data from the database.
Join SQL WhatsApp group to solve your SQL queries:
https://chat.whatsapp.com/EkcHb9rAaP1...
Join this channel to get access to perks:
/ @foxtechacademy
📌 Follow us on Instagram :
🔗 / aeron_zafar
🔗 / foxtechacademy
Thanks :
Fox Tech Academy
Instagram : / foxtechacademy
Facebook : / foxtechacademy
Telegram : https://t.me/codingPrep2020
Telegram : https://t.me/fox_the_sharp
Email : [email protected]
WhatsApp : +91 8252348796
#tcs #accenture #infosys #techmahindra #interview