Browse Code
I see there is no way in MySQL to drop tables using wildcards like 'temp_%', this simple PHP will help us do the following.
1. specify databases like 'anything%', so you check only the databases you need to.
2. specify tables like 'temp_%' , 'temp3_%' in an array so any number of temp wildcards possible.
3. loop through all databases and tables matching to drop the temp tables.
This makes it easy for you dropping many temp tables but be very careful about the wildcard, things may go completely wrong if you get the wildcard wrong.
Project Samples
Categories
DatabaseLicense
Creative Commons Attribution LicenseFollow MySQL DB Cleanup Script
Other Useful Business Software
Next-Gen Encryption for Post-Quantum Security | CLEAR by Quantum Knight
CLEAR by Quantum Knight is a FIPS-140-3 validated encryption SDK engineered for enterprises requiring top-tier security. Offering robust post-quantum cryptography, CLEAR secures files, streaming media, databases, and networks with ease across over 30 modern platforms. Its compact design, smaller than a single smartphone image, ensures maximum efficiency and low energy consumption.
Rate This Project
Login To Rate This Project
User Reviews
Be the first to post a review of MySQL DB Cleanup Script!
