MySQL Schema

select * from information_schema.columns where table_name=’mj_member’;

常用的有 COLUMN_NAME, DATA_TYPE, COLUMN_TYPE