The query instance in MySQL does not contain all 3 fields in a table

You need to query three fields for information about the existence of the tables in all the libraries under an instance, and the end of the surface does not include the _ number information.

SELECT Table_schema,table_name,sum (case "column_name in" (' User ', ' host ', ' password ') then 1 else 0 end) flag from infor Mation_schema. ' COLUMNS ' a

WHERE table_schema= ' MySQL '

GROUP BY Table_schema,table_name have flag>0;

The results are shown below

650) this.width=650; "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/ Images/localimage.png ") no-repeat center;border:1px solid #ddd;" alt= "Spacer.gif"/>650 "this.width=650;" src= "http ://s3.51cto.com/wyfs02/m02/71/4b/wkiol1xk-vlyupgqaae-akb4km0242.jpg "title=" 20150812_1.png "alt=" Wkiol1xk-vlyupgqaae-akb4km0242.jpg "/>

The flag represents the number of three fields.

This article from "Cloud Light Breeze Light" blog, declined reprint!

The query instance in MySQL does not contain all 3 fields in a table