mysql检查表中的字段是否存在

 SELECT column_name FROM information_schema.columns WHERE table_schema='eduyun31' and table_name = 'student' AND column_name = 'student_name';
原文地址:https://www.cnblogs.com/againn/p/7610705.html