麻烦来个SQL语句高手帮帮忙
AB两个表要把A表的lastchapter字段里的字符修改成B表的articlename字段的字符AB两表的共同点是A表的lastchapterid=B表的chapter...
A B两个表 要把A表的lastchapter字段里的字符 修改成B表的articlename字段的字符 A B两表的共同点是
A表的lastchapterid = B表的chapterid的最大数值 求高手
update A set lastchapter=B.articlename
from A join B on A.lastchapterid =B.chapterid
运行出现错误
#1064 - You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near 'from
求写出正确的 展开
A表的lastchapterid = B表的chapterid的最大数值 求高手
update A set lastchapter=B.articlename
from A join B on A.lastchapterid =B.chapterid
运行出现错误
#1064 - You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near 'from
求写出正确的 展开
1个回答
展开全部
UPDATE A SET lastchapter=B.articlename
FROM A INNER JOIN B ON A.lastchapterid =B.chapterid
WHERE B.chapterid=(SELECT MAX(chapterid) FROM B)
FROM A INNER JOIN B ON A.lastchapterid =B.chapterid
WHERE B.chapterid=(SELECT MAX(chapterid) FROM B)
追问
运行出错 哥 你都回答我3个号了 能来一次对的么 还是出错啊
本回答被提问者采纳
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
