先看插入語(yǔ)句是
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', '', '', '超級(jí)管理員', '本站', '', '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', '', '', '超級(jí)管理員', '本站', '', '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', ''),
根據(jù)規(guī)則下拉生成想需要的內(nèi)容
然后經(jīng)過(guò)復(fù)制處理用記事本進(jìn)行清洗格式 替換錯(cuò)誤的地方
構(gòu)建好內(nèi)容去數(shù)據(jù)庫(kù)中執(zhí)行MySQL語(yǔ)句即可
