使用如下sql表定义生成antd的表格列信息json，每一列信息格式化到一行上：CREATE TABLE ssr_compare_print ( cpl_id varchar(64) NOT NULL COMMENT '比对结果打印日志ID', cpl_barcode varchar(64) DEFAULT NULL COMMENT '比对结果记录条码号', cpl_source_gene_id varchar(64) DEFAULT NULL COMMENT '待比指纹记录ID', cpl_target_gene_id varchar(64) DEFAULT NULL COMMENT '对比指纹记录ID', cpl_source_gene_lib int(11) DEFAULT NULL COMMENT '源指纹库', cpl_target_gene_lib int(11) DEFAULT NULL COMMENT '目标指纹库', cpl_source_sample_barcode varchar(64) DEFAULT NULL COMMENT '源样品条码号', cpl_source_sample_name varchar(128) DEFAULT NULL COMMENT '源样品名称', cpl_source_sample_origin varchar(255) DEFAULT NULL COMMENT '源样品来源', cpl_source_sample_kind varchar(32) DEFAULT NULL COMMENT '源样品类型', cpl_target_sample_barcode varchar(64) DEFAULT NULL COMMENT '目标样品条码号', cpl_target_sample_name varchar(128) DEFAULT NULL COMMENT '目标样品名称', cpl_target_sample_origin varchar(255) DEFAULT NULL COMMENT '目标样品来源', cpl_target_sample_kind varchar(32) DEFAULT NULL COMMENT '目标样品类型', cpl_marker_count int(11) DEFAULT NULL COMMENT '比对位点总数', cpl_differ_markers longtext COMMENT '差异位点名称', cpl_differ_marker_count int(11) DEFAULT NULL COMMENT '差异位点数', cpl_no_differ_markers longtext COMMENT '无差异位点名称', cpl_no_differ_marker_count int(11) DEFAULT NULL, cpl_miss_markers longtext COMMENT '缺失位点名称', cpl_miss_marker_count int(11) DEFAULT NULL COMMENT '缺失位点数', cpl_no_judge_markers longtext, cpl_no_judge_marker_count int(11) DEFAULT NULL, cpl_sam_species varchar(32) DEFAULT NULL COMMENT '样品种属', cpl_is_locked varchar(2) DEFAULT NULL COMMENT '是否锁定，1/0-锁定/不锁定(默认值)', cpl_is_shared int(11) DEFAULT NULL COMMENT '是否允许共享本结果，是/否--共享/私有', cpl_relate_barcode varchar(128) DEFAULT NULL COMMENT '关联条码号，如合同号', cpl_manager varchar(64) DEFAULT NULL COMMENT '打印用户登录ID', cpl_user_ip varchar(60) DEFAULT NULL COMMENT '用户登录ip', cpl_html_path varchar(500) DEFAULT NULL COMMENT '打印页面地址', cpl_remark longtext COMMENT '备注', cpl_create_date datetime DEFAULT NULL COMMENT '创建日期', cpl_update_date datetime DEFAULT NULL COMMENT '更新日期', cpl_conclusion longtext COMMENT '结论', cpl_replace_miss_markers_str longtext COMMENT '缺失位点替换列表', cpl_is_same_name varchar(2) DEFAULT NULL COMMENT '是否为同名比对结果', cpl_is_reported varchar(2) DEFAULT NULL COMMENT '是否出具报告', PRIMARY KEY (cpl_id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8

以下是生成 antd 表格列信息的 JSON 格式化后的结果：

[
  {
    "title": "比对结果打印日志ID",
    "dataIndex": "cpl_id"
  },
  {
    "title": "比对结果记录条码号",
    "dataIndex": "cpl_barcode"
  },
  {
    "title": "待比指纹记录ID",
    "dataIndex": "cpl_source_gene_id"
  },
  {
    "title": "对比指纹记录ID",
    "dataIndex": "cpl_target_gene_id"
  },
  {
    "title": "源指纹库",
    "dataIndex": "cpl_source_gene_lib"
  },
  {
    "title": "目标指纹库",
    "dataIndex": "cpl_target_gene_lib"
  },
  {
    "title": "源样品条码号",
    "dataIndex": "cpl_source_sample_barcode"
  },
  {
    "title": "源样品名称",
    "dataIndex": "cpl_source_sample_name"
  },
  {
    "title": "源样品来源",
    "dataIndex": "cpl_source_sample_origin"
  },
  {
    "title": "源样品类型",
    "dataIndex": "cpl_source_sample_kind"
  },
  {
    "title": "目标样品条码号",
    "dataIndex": "cpl_target_sample_barcode"
  },
  {
    "title": "目标样品名称",
    "dataIndex": "cpl_target_sample_name"
  },
  {
    "title": "目标样品来源",
    "dataIndex": "cpl_target_sample_origin"
  },
  {
    "title": "目标样品类型",
    "dataIndex": "cpl_target_sample_kind"
  },
  {
    "title": "比对位点总数",
    "dataIndex": "cpl_marker_count"
  },
  {
    "title": "差异位点名称",
    "dataIndex": "cpl_differ_markers"
  },
  {
    "title": "差异位点数",
    "dataIndex": "cpl_differ_marker_count"
  },
  {
    "title": "无差异位点名称",
    "dataIndex": "cpl_no_differ_markers"
  },
  {
    "title": "无差异位点数",
    "dataIndex": "cpl_no_differ_marker_count"
  },
  {
    "title": "缺失位点名称",
    "dataIndex": "cpl_miss_markers"
  },
  {
    "title": "缺失位点数",
    "dataIndex": "cpl_miss_marker_count"
  },
  {
    "title": "缺失位点替换列表",
    "dataIndex": "cpl_replace_miss_markers_str"
  },
  {
    "title": "无法判断位点名称",
    "dataIndex": "cpl_no_judge_markers"
  },
  {
    "title": "无法判断位点数",
    "dataIndex": "cpl_no_judge_marker_count"
  },
  {
    "title": "样品种属",
    "dataIndex": "cpl_sam_species"
  },
  {
    "title": "是否锁定",
    "dataIndex": "cpl_is_locked"
  },
  {
    "title": "是否允许共享本结果",
    "dataIndex": "cpl_is_shared"
  },
  {
    "title": "关联条码号，如合同号",
    "dataIndex": "cpl_relate_barcode"
  },
  {
    "title": "打印用户登录ID",
    "dataIndex": "cpl_manager"
  },
  {
    "title": "用户登录ip",
    "dataIndex": "cpl_user_ip"
  },
  {
    "title": "打印页面地址",
    "dataIndex": "cpl_html_path"
  },
  {
    "title": "备注",
    "dataIndex": "cpl_remark"
  },
  {
    "title": "创建日期",
    "dataIndex": "cpl_create_date"
  },
  {
    "title": "更新日期",
    "dataIndex": "cpl_update_date"
  },
  {
    "title": "结论",
    "dataIndex": "cpl_conclusion"
  },
  {
    "title": "是否为同名比对结果",
    "dataIndex": "cpl_is_same_name"
  },
  {
    "title": "是否出具报告",
    "dataIndex": "cpl_is_reported"
  }
]