SELECT TABLE_NAME,COLUMN_NAME,CHARACTER_MAXIMUM_LENGTH,COLUMN_COMMENT FROM COLUMNS WHERE TABLE_SCHEMA=‘zhongchao‘ AND COLUMN_NAME LIKE ‘Is%‘SELECT * FROM TABLES WHERE TABLE_SCHEMA=‘zhongchao‘
mysql information_schema
原文：http://www.cnblogs.com/tq1226112215/p/4743129.html
