https://www.cnblogs.com/ParanoiaApe/p/9005266.html
select column_name,data_type from information_schema.columns where table_schema='database_name' and table_name='table_name';
https://www.cnblogs.com/ParanoiaApe/p/9005266.html
select column_name,data_type from information_schema.columns where table_schema='database_name' and table_name='table_name';