Difference Between Delete and Truncate.Part:1-SQL-Ep:8 🔥 #delete #truncate #sql #bengali

Hi,
Hope you all are doing great! Let's learn SQL together. 🚀

📌 Chapters ❤
⏱️ (00:00) Introduction & Theory
⏱️ (02:09) Theory Discussion
⏱️ (03:24) Difference Between Delete and Truncate
⏱️ (04:45) Difference Between Delete and Truncate : Where Caluse
⏱️ (09:01) Difference Between Delete and Truncate : Counter
⏱️ (17:26) Difference Between Delete and Truncate : Trigger
⏱️ (32:37) Revise
⏱️ (33:39) End Of Chapters

💬 Like, Comment, Share, and Subscribe for more tutorials!
I appreciate your support! 🚀

📜 Additional Learning Resources:
📄 SQL Notes & Documentation:

🎥 Related Video Tutorials or Playlist:

🔗 Other Playlists & Tutorials:

🔗 Useful Links:

📚 SQL Overview:
SQL (Structured Query Language) is a standardized programming language for managing and manipulating relational databases(RDBMS: Relational Database Management System). It is widely used to interact with databases and perform various operations, such as querying, updating, inserting, and deleting data.

💡 RDBMS(Relational Database Management System) Key Features:
📌 Tabular Structure:
✔ Data is stored in tables (rows and columns).
✔ Each table has a unique name and consists of columns (fields) and rows (records).

💡Data Manipulation Language (DML)
Data Manipulation Language (DML) is a subset of SQL. It is used to interact with and manipulate the data store in a database. It enables users to perform operations that involve retrieving, inserting, updating, and deleting data records.

💡SELECT and DQL
Some frameworks classify SELECT under Data Query Language (DQL) to distinguish read operations (querying) from write operations (modifying data). However, in traditional SQL standards and many database systems (e.g., MySQL), SELECT is still grouped under DML.

💡Transactional Support
DML operations are often used within transactions (e.g., COMMIT and ROLLBACK) to ensure data consistency and integrity.

💡DELETE – The DELETE query in MySQL is used to remove one or more records from a table.
DELETE FROM table
[WHERE conditions];

📌Delete a specific row
DELETE FROM table_name where [unique column ];

📌Delete all rows from a table
DELETE FROM table_name;

📌Delete rows with a null condition
DELETE FROM table_name where column_name is null;

📌Delete with LIMIT
DELETE FROM table_name
LIMIT number;

✔No WHERE clause deletes all rows in the table.
✔ALWAYS use WHERE unless intentionally deleting all records
✔Foreign keys - May block deletions if referential integrity would be violated
✔SOFT Delete : UPDATE table SET is_deleted = 1 WHERE condition;

💡The safe update mode('sql_safe_updates') in MySQL is on, and this is a safety feature designed to prevent accidental or unintended mass updates or deletions of data.

SHOW VARIABLES LIKE 'sql_safe_updates';
To Disable Safe Update Mode : SET SQL_SAFE_UPDATES = 0;
To Enable Safe Update Mode : SET SQL_SAFE_UPDATES = 1;

💡Delete
DML (Data Manipulation Language)
Slower (deletes rows one by one)
Supports conditional deletion (WHERE)
Does not reset the counter
Fires BEFORE/AFTER DELETE triggers
Can be rolled back in a transaction
Works with constraints

💡Truncate
DDL (Data Definition Language)
Faster (drops and recreates the table)
No WHERE (always removes all rows)
Resets the counter
Does not fire triggers
Cannot be rolled back
Fails if foreign keys exist

#SQL #SQLTutorial #SQLBangla #SQLForBeginners #LearnSQL #Database #SQLQueries #MySQL #SQLServer #SQLBanglaTutorial #BengaliProgramming #SQLJoins #DatabaseManagement #SQLQueryTutorial #ProgrammingInBengali
#SQL#LearnSQL#SQLTutorial#SQLBengali#SQLForBeginners#SQLDDL#DatabaseTutorial#BanglaTutorial#SQLCourse#SQLTraining#SQLCommands#SQLFullCourse#DataDefinitionLanguage#SQLDatabase#SQLTips#dml#datamanipulationlanguage

I appreciate your support! 🚀

[PritamDas-unul]

sir group by clause basic to advance using having clause er video upload krun sir khub drkr then joins niye and set operators plz sir khub drkr