pbootcms用excel批量导入数据的方法

先看插入语句是 

INSERT INTO `ay_content`(`id`, `acode`, `scode`, `subscode`, `title`, `titlecolor`, `subtitle`, `filename`, `author`, `source`, `outlink`, `date`, `ico`, `pics`, `picstitle`, `content`, `tags`, `enclosure`, `keywords`, `description`, `sorting`, `status`, `istop`, `isrecommend`, `isheadline`, `visits`, `likes`, `oppose`, `create_user`, `update_user`, `create_time`, `update_time`, `gtype`, `gid`, `gnote`) VALUES 

('35756','cn', '36', '', '美女壁纸', '#333333', '', '', '超级管理员', '本站', '', '2022-11-20 13:35:18', '/static/upload/image/20221023/3.jpg', '', '', '', '', '', '', '', 255, '1', '0', '0', '0', 0, 0, 0, 'admin', 'admin', '2022-11-20 13:39:33', '2022-11-20 13:39:33', '4', '0', ''),

('35757','cn', '36', '', '美女壁纸', '#333333', '', '', '超级管理员', '本站', '', '2022-11-20 13:35:18', '/static/upload/image/20221023/4.jpg', '', '', '', '', '', '', '', 255, '1', '0', '0', '0', 0, 0, 0, 'admin', 'admin', '2022-11-20 13:39:33', '2022-11-20 13:39:33', '4', '0', ''),

根据规则下拉生成想需要的内容

然后经过复制处理用记事本进行清洗格式 替换错误的地方

构建好内容去数据库中执行mysql语句即可