Repair all tables in one go

Question

How to check all the tables in the database in one go?

Rather than typing the query check table ''tablename''; for all the tables one by one.

Is there any simple command like check all or anything like that?

Answer 1

In the command line you can try this:

mysqlcheck -A --auto-repair

For more information: http://dev.mysql.com/doc/refman/5.0/en/mysqlcheck.html