Tag

DROP

0 views collected around this technical thread.

Java Tech Enthusiast
Java Tech Enthusiast
Jun 8, 2025 · Databases

Why DELETE Is Discouraged in MySQL and When to Use DROP or TRUNCATE

This article explains MySQL's storage architecture, compares the DELETE, TRUNCATE, and DROP commands, shows their performance and side‑effects, and provides practical guidance on choosing the safest and most efficient way to remove data from a MySQL table.

DELETEDROPDatabase Storage
0 likes · 9 min read
Why DELETE Is Discouraged in MySQL and When to Use DROP or TRUNCATE
Laravel Tech Community
Laravel Tech Community
Aug 3, 2023 · Databases

MySQL Data Deletion Methods: DELETE, TRUNCATE, and DROP

This article explains the three primary ways to delete data in MySQL—using DELETE, TRUNCATE, and DROP—detailing their execution speed, underlying mechanisms, storage‑engine differences, and best‑practice considerations such as space reclamation and auto‑increment handling.

DELETEDROPDatabase
0 likes · 5 min read
MySQL Data Deletion Methods: DELETE, TRUNCATE, and DROP
Laravel Tech Community
Laravel Tech Community
Sep 8, 2022 · Databases

Understanding MySQL Data Deletion Methods: DELETE, TRUNCATE, and DROP

The article explains the three primary MySQL data removal commands—DELETE, TRUNCATE, and DROP—detailing their execution speed, underlying mechanisms, impact on disk space for InnoDB and MyISAM engines, and best‑practice usage such as running OPTIMIZE TABLE after DELETE.

DELETEDROPInnoDB
0 likes · 7 min read
Understanding MySQL Data Deletion Methods: DELETE, TRUNCATE, and DROP
Selected Java Interview Questions
Selected Java Interview Questions
Oct 18, 2020 · Databases

MySQL Data Deletion Methods: DELETE, TRUNCATE, and DROP

This article explains the three primary ways to remove data in MySQL—DELETE, TRUNCATE, and DROP—comparing their execution speed, underlying mechanisms, impact on disk space, transaction behavior, and how to reclaim space with OPTIMIZE, while providing practical SQL examples and usage warnings.

DELETEDROPDatabase
0 likes · 6 min read
MySQL Data Deletion Methods: DELETE, TRUNCATE, and DROP
AntTech
AntTech
Sep 27, 2020 · Artificial Intelligence

Question Directed Graph Attention Network for Numerical Reasoning over Text (QDGAT)

The paper introduces QDGAT, a question‑directed graph attention network that enhances numerical reasoning in reading comprehension by explicitly modeling relationships among numbers, entities, and questions, and demonstrates its effectiveness through extensive experiments on the DROP dataset.

DROPNLPQDGAT
0 likes · 7 min read
Question Directed Graph Attention Network for Numerical Reasoning over Text (QDGAT)