Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
CREATE EVENT update_statistics ON SCHEDULE EVERY 1 WEEK STARTS "2024-01-07 03:00:00" DO BEGIN ANALYZE TABLE orders, order_items, products, users; ANALYZE TABLE inventory, shipments, payments; INSERT INTO maintenance_log (task, run_at) VALUES ("analyze_tables", NOW()); END; -- Check when statistics were last updated: SELECT table_name, update_time FROM information_schema.tables WHERE table_schema = "mydb" ORDER BY update_time;
Result
Open