mysql导入数据的格式转换_数据库导入格式转换

MYsql数据库格式转换。能不能把UPDATE`cdb_forums`SET`fid`=2,`fup`=1,`type`='forum',`name`='『新手报到』',`status`=1,`displayorder`=0,`styleid`=0,`threads`=134,`posts`=763,`...

MYsql数据库格式转换。 能不能把

UPDATE `cdb_forums` SET `fid` = 2, `fup` = 1, `type` = 'forum', `name` = '『新手报到』', `status` = 1, `displayorder` = 0, `styleid` = 0, `threads` = 134, `posts` = 763, `todayposts` = 0, `lastpost` = '1621 新手报到 1281450212 用双脚去感受', `allowsmilies` = 1, `allowhtml` = 0, `allowbbcode` = 1, `allowimgcode` = 1, `allowmediacode` = 1, `allowanonymous` = 0, `allowshare` = 1, `allowpostspecial` = 0, `allowspecialonly` = 0, `alloweditrules` = 0, `allowfeed` = 0, `recyclebin` = 0, `modnewposts` = 0, `jammer` = 0, `disablewatermark` = 0, `inheritedmod` = 0, `autoclose` = 0, `forumcolumns` = 0, `threadcaches` = 0, `alloweditpost` = 1, `simple` = 0, `modworks` = 0, `allowtag` = 1, `allowglobalstick` = 1 WHERE `cdb_forums`.`fid` = 2;

改成

(2, 1, 'forum', '『新手报到』', 1, 0, 0, 13, 18, 0, '1621 新手报到 1281450212 用双脚去感受', 1, 0, 1, 1, 1, 0, 1, 63, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 1, 1);

这个格式？

展开