BigQuery automates data prep, analysis, and predictions with built-in AI assistance.
Build and deploy ML models using familiar SQL. Automate data prep with built-in Gemini. Query 1 TB and store 10 GB free monthly.
Try Free
Full-stack observability with actually useful AI | Grafana Cloud
Our generous forever free tier includes the full platform, including the AI Assistant, for 3 users with 10k metrics, 50GB logs, and 50GB traces.
Built on open standards like Prometheus and OpenTelemetry, Grafana Cloud includes Kubernetes Monitoring, Application Observability, Incident Response, plus the AI-powered Grafana Assistant. Get started with our generous free tier today.
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...