DEV Community

Reynaldo Quispe Soca
Reynaldo Quispe Soca

Posted on

can't drop a table in mysql, it stays in "Executing query"

#mysql
  1. Run SHOW PROCESSLIST;
  2. Identify the proccess is running and copy id
  3. Run KILL {id};
  4. finally DROP TABLE_NAME

Top comments (0)

Read next

maxstalker profile image

FlowDiver: The Road to SSR - Part 1

Max Daunarovich -

romulogatto profile image

Introduction to Web Scraping with BeautifulSoup

Romulo Gatto -

manoj_004d profile image

Integrate CanvasJS Charts in Your Nuxt.js App

Manoj Mohan -

dleif profile image

SQLServer service status monitoring on Windows with Prometheu.

Atsushi Suzuki -