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

 SELECT column_name FROM information_schema.columns WHERE table_schema='eduyun31' and table_name = 'student' AND column_name = 'student_name';

 

posted @ 2017-09-29 13:51  Againn  阅读(2598)  评论(0编辑  收藏  举报