例如 :
tbl_ifo id | name | age | gender ---------------------------- 1 | John | 15 | Male 2 | Maria | 18 | Female 3 | Steph | 19 | Female 4 | Jay | 21 | Male
如何使用mysql计数此表的列?
SELECT count(*) FROM information_schema.columns WHERE table_name = 'tbl_ifo'