查询表字段的详细信息 select * from information_schema.columns where table_name = ‘TableName’ 查询表字段的个别信息 select column_name,data_type,column_default,is_nullable from information_schema.columns where table_name = ‘TableName’