MYSQL drop table if all rows within a column are specific value

Thread Starter

zazas321

Joined Nov 29, 2015
936
Hello. In my application, I must delete the table if all the rows within a column are specific value. An example can be found here:
https://www.db-fiddle.com/f/siZmmKWLjRDdpYX6deEPYF/0

Throughout my program, I am modifying "Status_s" column and changing the status from "IDLE" to done. When all the rows are "DONE" I need to drop the table.
Can someone help me understand how do I drop table with a condition. Thanks in advance
 
Top