Select count from each table from a list stored on a table

Question

I have a table tbls with a field name containing names of tables.

I'm trying to form a statement to get the number of rows of each of this tables.

Should I use a stored procedure or is there a simpler way to do it?

which mysql version are you using? – Nesim Razon Apr 22 '12 at 08:41 — Nesim Razon, Apr 22 '12 at 08:41

score 1 · Accepted Answer · edited May 23 '17 at 10:34

1

There is a thread that talks about how you can Get record counts for all tables in MySQL database. Using the result, you can constraint the result set to tables specified in the tbls table.

edited May 23 '17 at 10:34

Community

answered Apr 22 '12 at 08:45

David Z.

1 Answers1