pw_members是会员表 username是会员名称
pw_threads是帖子表 author是会员名称
当我用select * from pw_threads where author='淮安小张'就查询出288页的记录
我想把“淮安小张”,用pw_members表里的username的值随机跟新一下 该怎么实现呀
pw_threads是帖子表 author是会员名称
当我用select * from pw_threads where author='淮安小张'就查询出288页的记录
我想把“淮安小张”,用pw_members表里的username的值随机跟新一下 该怎么实现呀
pdate pw_threads set author=(SELECT username FROM `pw_members` where IsCorporation=0 Order By Rand() Limit 1) where author='淮安小张'