mysql sum count from multiple table using wildcard -

mysql sum count from multiple table using wildcard -

i have tables a_0, a_1,...a_9, , want count rows number or delete them:

select count(*) a_*; delete a_*;

is wildcard back upwards or should walk around way?

select won't target several different tables , unless join/union them form middle step result.

like this:

select count(*) ( select * a1 union select * a2 ....)

no table wild card supported in sql

mysql