/
githubmirror
/
sqlc
Обзор
Документация
Войти
/
githubmirror
/
sqlc
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
internal/endtoend/testdata/delete_join/mysql/query.sql
34 строки
706 B
Willem de Groot
Support DELETE with JOIN on subquery (#4023)
03 авг 2025, 02:42
Не верифицирован
03 авг 2025, 02:42
eb4b0b5
Код
Авторство
О чём код?
-- name: DeleteJoin :exec DELETE jt.*, pt.* FROM join_table as jt JOIN primary_table as pt ON jt.primary_table_id = pt.id WHERE jt.id = ? AND pt.user_id = ?; -- name: DeleteLeftJoin :exec DELETE jt.*, pt.* FROM join_table as jt LEFT JOIN primary_table as pt ON jt.primary_table_id = pt.id WHERE jt.id = ? AND pt.user_id = ?; -- name: DeleteRightJoin :exec DELETE jt.*, pt.* FROM join_table as jt RIGHT JOIN primary_table as pt ON jt.primary_table_id = pt.id WHERE jt.id = ? AND pt.user_id = ?; -- name: DeleteJoinWithSubquery :exec DELETE pt FROM primary_table pt JOIN (SELECT 1 as id) jt ON pt.id = jt.id;