gpt4 book ai didi

mysql - 转mysql select to delete statement - 我怎么办?

转载 作者:可可西里 更新时间:2023-11-01 08:21:17 26 4
gpt4 key购买 nike

<分区>

我只想从一个表中删除,但我必须根据相关表中的条件进行选择。我之前在此处找到的示例讨论了从一张表中删除的内容。

如何将下面的 select 变成 delete 语句?

select r.id, r.reminder_date, c.full_name, c.company
from reminders r
left join clients c
on r.client_id = c.id
where (c.full_name is null
or c.full_name = "")
AND (c.company is null
or c.company = "");

谢谢

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