PW【修改UID】方法共享

蒋金阳

工具：PHPMYADMIN <br /><br />在SQL中执行： <br /><br />UPDATE `wng_attachs` SET `uid`=1001 WHERE `uid`=16777215;<br />UPDATE `wng_memberdata` SET `uid`=1001 WHERE `uid`=16777215;<br />UPDATE `wng_members` SET `uid`=1001 WHERE `uid`=16777215;<br />UPDATE `wng_threads` SET `authorid`=1001 WHERE `authorid`=16777215;<br />UPDATE `wng_posts` SET `authorid`=1001 WHERE `authorid`=16777215; <br /><br />语句解释： <br /><br />UPDATE `wng_attachs` SET `uid`=115 WHERE `uid`=21768; 附件信息 <br />UPDATE `wng_memberdata` SET `uid`=115 WHERE `uid`=21768; 会员信息 <br />UPDATE `wng_members` SET `uid`=115 WHERE `uid`=21768; 注册信息 <br />UPDATE `wng_threads` SET `authorid`=115 WHERE `authorid`=21768; 主题信息 <br />UPDATE `wng_posts` SET `authorid`=115 WHERE `authorid`=21768; 帖子信息 <br /><br />最后执行： <br /><br />ALTER TABLE `wng_members` AUTO_INCREMENT = 115 <br /><br />其中21768为修改前的UID，115为修改后的UID<br /><br /><blockquote class="blockquote">From: http://80year.co.cc/read.php?tid=212  Powered by PHPWind.com</blockquote>