pbootcms如何用表格进行数据批量导入
先看插入语句是
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语句即可