Home  >  Article  >  Backend Development  >  如何用一条SQL语句删除两个表中的记录

如何用一条SQL语句删除两个表中的记录

WBOY
WBOYOriginal
2016-06-06 20:52:391800browse

MYSQL如何用一条SQL语句删除两个表中的记录

回复内容:

MYSQL如何用一条SQL语句删除两个表中的记录

delete a.*,b.* from a,b where a.id=b.aid and a.id=1;

删除a,b表中,所有关于a.id=b.aid=1的数据。

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn