Difference Between Delete and Truncate.Part:2-SQL-Ep:9 🔥
Hi,
Hope you all are doing great! Let's learn SQL together. 🚀
📌 Chapters ❤
⏱️ (00:00) Introduction
⏱️ (00:26) Theory Discussion
⏱️ (03:45) Difference Between Delete and Truncate : Transaction
⏱️ (14:03) Show Variables : Auto Commit:On
⏱️ (17:55) Difference Between Delete and Truncate : Foreign key
⏱️ (25:17) How To Do Delete Operation When Foreign Key Relation Exist : 1
⏱️ (32:27) How To Do Delete Operation When Foreign Key Relation Exist : 2
⏱️ (35:20) How To Do Delete Operation When Foreign Key Relation Exist : 3
⏱️ (40:50) How To Do Delete Operation When Foreign Key Relation Exist : CASCADE
⏱️ (46:12) Trunce Operation When Foreign Key Exist
⏱️ (59:52) End Of Chapters
⏱️ (01:01:24) Support My Journey
📌 Join my Telegram for updates: https://t.me/contactajoydebnath
🔗 Visit my website for more tutorials: https://contactajoydebnath.com/
💬 Like, Comment, Share, and Subscribe for more tutorials!
🔔 Subscribe to my channel: / @contactajoydebnath
I appreciate your support! 🚀
📜 Additional Learning Resources:
📄 SQL Notes & Documentation:
https://docs.google.com/document/d/1d...
🎥 Related Video Tutorials or Playlist:
📌 SQL Playlist: 👉 • SQL | Bangla Tutorial
🔗 Other Playlists & Tutorials:
📌 Core Java Playlist: • Core Java
📌 Scanner Class Playlist: • Scanner Class | Bangla Tutorial
📌 Spring Framework Playlist: • Spring Framework
📌 SQL Tutorial Playlist : • JDBC
📌 JDBC Tutorial Playlist : • JDBC
🔗 Useful Links:
📌 Eclipse IDE Download: https://www.eclipse.org/downloads/pac...
📌 JDK (Java Development Kit): https://www.oracle.com/java/technolog...
📌 MySQL Installer: https://dev.mysql.com/downloads/insta...
📚 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.
💡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! 🚀