mysql 查询某个特定值在整个数据库中所在的表和字段 (已知数据库和字段值查询表明和字段名)

DROP TABLE if EXISTS temp; CREATE TABLE temp(tablename VARCHAR(255),LieName VARCHAR(255)); delimiter $$ DROP procedure IF EXISTS getDataByDbName $$ CREATE procedure getDataByDbName(in dbName VARCHAR(255),IN ziduan VARCHAR(255)) BEGIN DECLARE num INT; SET @STMT =CONCAT("SELECT COUNT(*) FROM ",dbName