select concat(" select * from `“,TABLE_SCHEMA,”`.",TABLE_NAME
, ’ where is_deleted = 0 group by source_id
having count(*) >1 and source_type = ‘‘goods’’
order by id desc ’
) from information_schema.TABLES where TABLE_NAME = ‘表名称’
mysql information_schema 拼接数据源的所有库的sql
最新推荐文章于 2024-10-18 10:35:48 发布