mysql查询表中的所有字段

select column_name, table_name from information_schema.columns where table_schema='yizhan' and column_name = 'phone';