gpt4 book ai didi

mysql - INNER JOIN 用作 SELECT 但不用作 DELETE

转载 作者:行者123 更新时间:2023-11-29 03:52:14 26 4
gpt4 key购买 nike

<分区>

为什么会出现语法错误

DELETE FROM `print_mailing_request` pmr
INNER JOIN `person` p
ON p.id = pmr.person AND p.email LIKE '%@TEST.COM'
WHERE
pmr.sent_to_fulfiller != 'y'

什么时候可以正确无误地工作?

SELECT * FROM `print_mailing_request` pmr
INNER JOIN `person` p
ON p.id = pmr.person AND p.email LIKE '%@TEST.COM'
WHERE
pmr.sent_to_fulfiller != 'y'

26 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com