Hello everyone.

I need repair all mysql tables of database db_test (and check and optimize them) in one command and I try this:

PHP Code:
CHECK table db_test._temp_tbl
 
REPAIR table db_test._temp_tbl;
 
OPTIMIZE table db_test._temp_tbl
---Working

PHP Code:
CHECK tables db_test.*;
 
REPAIR tables db_test.*;
 
OPTIMIZE tables db_test.*; 
---Not working: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*' at line 1

PHP Code:
CHECK all tables db_test;
 
REPAIR all tables db_test;
 
OPTIMIZE all tables db_test
---Not working: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'all tables db_test' at line 1

Can you help me?