复制MySQL> use imss;   MySQL> select if(exists(select * from information_schema.columns where table_name

 = imss_righttemplate and column_name=id_righttemplate),用命yes,no) as cz ;  1.2.3.