Re: Deleting Tables from the Data Folder

[Keith Larson]

Not to avoid the answer but I think overall you could do this a different way.

Sounds like you are creating "real" tables.

Instead create TEMPORARY tables and they will go away anyway at close of session.

CREATE TEMPORARY TABLE `temporary_table` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`date_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ;


If you need it available for others to use... them create a MEMORY table and so it will be fast and easy to remove right away as well.

More information here :
http://anothermysqldba.blogspot.com/2013/06/memory-and-temporary-tables.html

Just trying to help....

http://anothermysqldba.blogspot.com