56,673
社区成员
发帖
与我相关
我的任务
分享
set group_concat_max_len = 1024*10224 * 1024;
set @db1='kafka', @db2='ods';
select group_concat(concat(
'select ', quote(a.table_name), 'as name',
', (select count(*) from ', a.table_schema, '.', a.table_name, ') as ', a.table_schema,
', (select count(*) from ', b.table_schema, '.', b.table_name, ') as ', b.table_schema
) separator ' union all ')
into @sql
from information_schema.tables a, information_schema.tables b
where a.table_name=b.table_name
and a.table_schema=@db1 and b.table_schema=@db2
;
set @sql=concat('select *, if(', @db1, '=', @db2, ', 1, 0) as eq from(', @sql, ') data');
prepare st from @sql;
execute st;
deallocate prepare st;