Jamie's Blog

  • Home
  • About me
  • Blogs

DROP

Backend Development

What is the difference between TRUNCATE, DELETE and DROP statements?

TRUNCATE TRUNCATE Command is a Data Definition Language operation. It is used to remove all the records from a table. It deletes all the records from an existing table but not the table itself. The structure or schema of the table is preserved. Truncate command marks the table for deallocation. This operation Read more…

By jamie, 4 years28 December 2021 ago
Categories
  • AWS (2)
  • Backend Development (36)
  • Bootstrap (1)
  • Computer Science (3)
  • Crawler (1)
  • CSS (3)
  • Database (11)
  • Design Model (1)
  • Docker (12)
  • Elasticsearch (2)
  • eslint (1)
  • Frontend Development (25)
  • git (1)
  • Gradle (1)
  • Gson (1)
  • hibernate (1)
  • HTML (1)
  • Jackson (2)
  • Java (13)
  • javascript (3)
  • json (2)
  • junit (4)
  • Linux (7)
  • Mybatis (4)
  • MySQL (7)
  • Networks (3)
  • Nginx (1)
  • prettier (1)
  • Pyppeteer (1)
  • React (16)
  • Spring (2)
  • Springboot (2)
  • Strapi (2)
  • version control (1)
  • wordpress (2)
  • About me
  • Blogs
  • Front Page
Hestia | Developed by ThemeIsle