Home  >  Article  >  Database  >  MySQL 使用联合 (JOIN) 删除表记录

MySQL 使用联合 (JOIN) 删除表记录

WBOY
WBOYOriginal
2016-06-07 14:54:581350browse

删除A表中的数据,满足B表的条件 JOIN MySQL DELETE t1 FROM table1 t1 INNER JOIN table2 t2 ON t1.ref_id=t2.id AND t2.id=12

删除A表中的数据,满足B表的条件 JOIN MySQL
DELETE t1 FROM table1 t1 INNER JOIN table2 t2 ON t1.ref_id=t2.id AND t2.id=12
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
Previous article:array to csvNext article:数据库 全局搜索