mysql - 左加入删除查询

Question

我有一个 mysql 查询的问题..查询是:

DELETE address_book.*, address_book_tags.*, address_book_tags_contacts.* from address_book, address_book_tags, address_book_tags_contacts
            LEFT JOIN address_book_tags_contacts on address_book.id = address_book_tags_contacts.contactId 
            LEFT JOIN address_book_tags on address_book_tags_contacts.tagId = address_book_tags.id
    WHERE address_book.idVitalStatistic=1;

错误是:

RuntimeException' with message 'Not unique table/alias: 'address_book_tags_contacts' (1066)'

我能做什么？

Answer 1

您在 FROM 和 LEFT JOIN 中都有表 address_book_tags_contacts 和 address_book_tags。如果那是故意的(我不这么认为)，你必须给他们一个独特的名字。但我想您应该从 FROM 子句中删除这些表名。