MySQL 更新时选择

发布于 2024-11-27 00:21:09 字数 305 浏览 0 评论 0原文

我写了一个查询，并且我确信它是正确的形式。但我收到错误。 :) 我可以做其他查询吗？

UPDATE pages SET 
    p_name = 'Activites', 
    p_active = 1, 
    p_parent = 'sport', 
    p_parent_id=(
    SELECT p_id FROM pages WHERE p_link='sport' LIMIT 1
    ), 
    p_link = 'activites' 
    WHERE p_id = 9;

谢谢。

原文

I wrote a query, and Im sure that it was right form.
But I get an error. :)
May I do this query else?

UPDATE pages SET 
    p_name = 'Activites', 
    p_active = 1, 
    p_parent = 'sport', 
    p_parent_id=(
    SELECT p_id FROM pages WHERE p_link='sport' LIMIT 1
    ), 
    p_link = 'activites' 
    WHERE p_id = 9;

Thank you.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

花海 2024-12-04 00:21:09

你不能这样做。您需要交叉连接表和子查询：

UPDATE 
  pages AS p
CROSS JOIN (
  SELECT p_id FROM pages WHERE p_link='sport' LIMIT 1
) AS sq
SET 
  p.p_name = 'Activites', 
  p.p_active = 1, 
  p.p_parent = 'sport', 
  p.p.parent_id= sq.p_id 
  p.p_link = 'activites' 
WHERE p.p_id = 9;

You can't do that this way. You need to cross join the table and subquery:

UPDATE 
  pages AS p
CROSS JOIN (
  SELECT p_id FROM pages WHERE p_link='sport' LIMIT 1
) AS sq
SET 
  p.p_name = 'Activites', 
  p.p_active = 1, 
  p.p_parent = 'sport', 
  p.p.parent_id= sq.p_id 
  p.p_link = 'activites' 
WHERE p.p_id = 9;

回复收藏 0 原文

~没有更多了~