select
TABLE_NAME
from
information_schema.`COLUMNS`
where
TABLE_SCHEMA=
'dbname'
and
COLUMN_NAME=
'role_id'
select
TABLE_NAME
from
information_schema.`COLUMNS`
where
TABLE_SCHEMA=
'dbname'
and
COLUMN_NAME=
'role_id'
转载于:https://www.cnblogs.com/daizhuacai/archive/2013/02/26/2933924.html