mysql--字段

mysql--去除自增Id列

  
  SELECT substr(group_concat(COLUMN_NAME),4) FROM information_schema.columns
WHERE table_schema = 'dim'
  AND TABLE_NAME = 'dim_car_info'

mysql--字段描述列表

SELECT COLUMN_NAME,
       data_type,
       column_type,
       column_comment
FROM information_schema.columns
WHERE table_schema = 'dim'
  AND TABLE_NAME = 'abc'