Query the data of a specified date in a specified table in mysql database? There are details

Question

{Code...} The above is the existing query statement, which can find all the tables in the entire database and how much data is in the table. Now I want to break it down: For example, there are 1,000 tables in the test database, and I only want to check 200 of them (specified) that contain the specified date (there is a date field, the type is medi...

过去多啦不再A梦 · Answer

use information_schema;
select table_name,table_rows from tables
where TABLE_SCHEMA = 'test' and TABLE_NAME in ('Specification 1','Specification 2',.......,'Specification 200') and UPDATE_TIME = 'Specification Time'
order by table_rows desc;

给我你的怀抱 · Answer

The author is talking about finding the table containing the date field of the specified type, right? information_schema also has a columns table, and you can do a joint query

select a.table_name,a.table_rows from tables a join columns b on a.table_name=b.table_name and a.table_schema=b.table_schema
where a.TABLE_SCHEMA = 'test' and b.DATA_TYPE='mediumtext' and COLUMN_NAME='指定日期字段'
order by table_rows desc;