Tweet 2 has 3 comments so loops out tweet 2 three times)"SELECT tweets.accountno, tweets.id,tweets.tweet,tweets.createdat,tweets.userid,users.name,users.avatar,users.biog,comments.commentFROM tweets INNE
表,用一个与users.id匹配的整数替换tweets.from_user。其次,我想填充相应的users.from_user_id,最后,我想删除tweets.from_user_id,以便最终结果如下所示:------------------------我只走了这么远: (SELECT id FROM users WHERE from_user = tweets.from_user)
WHEREUPDATE users