mysql 显示字段信息内容

select COLUMN_NAME from information_schema.columns where table_name='userinfo' ; 

select * from information_schema.columns where table_name='userinfo';