select count(*) > 1 from ( SELECT COLUMN_NAME, DATA_TYPE, IS_NULLABLE, COLUMN_DEFAULT FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = ‘test‘ AND table_schema = ‘test‘ and COLUMN_NAME = ‘ID‘ ) v
Mysql 判断字段存在
原文：http://my.oschina.net/u/582827/blog/308934
