Access Google's best plus Claude, Llama, and Gemma. Fine-tune and deploy from one console.
Build, govern, and optimize agents and models with Gemini Enterprise Agent Platform.
Start Free
Build Securely on AWS with Proven Frameworks
Lay a foundation for success with Tested Reference Architectures developed by Fortinet’s experts. Learn more in this white paper.
Moving to the cloud brings new challenges. How can you manage a larger attack surface while ensuring great network performance? Turn to Fortinet’s Tested Reference Architectures, blueprints for designing and securing cloud environments built by cybersecurity experts. Learn more and explore use cases in this white paper.
PHP Script to drop tables on all/some databases with wildcards
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.
libbatch implements typical batch process functions. These functions include common SQL operations, functions for working with temp files, logging functions (with severity, priority, colors, and verbosity), functions that work with files and directories,