mysql delete语法与select有什么不同？

Question

这一点：

SELECT * 
  FROM tbl_playlists, tbl_playlistsongs 
 WHERE tbl_playlists.playlist_id = tbl_playlistsongs.playlist_id 
   AND tbl_playlists.playlist_id = 1

...works没有问题。但是：

DELETE from tbl_playlists, tbl_playlistsongs 
 WHERE tbl_playlists.playlist_id = tbl_playlistsongs.playlist_id 
   AND tbl_playlists.playlist_id = 1

...says我有一个语法错误。除了SELECT * vs DELETE之外，它们是相同的。对我来说，这仍然是非常合理的..但我一定是漏掉了什么！

Answer 1

传统的SQL不支持多表删除，但MySQL支持。这意味着您使用的是特定于MySQL的语法：

DELETE pl, pls
  FROM TBL_PLAYLISTS pl
  JOIN TBL_PLAYLISTSONGS pls ON pls.playlist_id = pl.playlist_id
 WHERE pl.playlist_id = 1

参考资料：

• DELETE (MySQL documentation)