Friday, January 11, 2013

Delete rows in one table from join two tables in MySQL



In MYSQL, we can only select one table from multi tables:
 SELECT tableA.*  FROM tableA A,  tableB B   WHERE  A.id=B.id AND R.member_id AND B.id=1;

If we use
 DELETE   FROM tableA A,  tableB B   WHERE  A.id=B.id AND R.member_id AND B.id=1;

This will delete the rows  both in tableA and tableB which satisfy the conditions.

So if we only want to delete  the rows in tableA, not in tableB?
We can use the following MySQl query
DELETE FROM tableA USING tableA, tableB WHERE tableA.id=tableB.id AND tableB.id=1;



No comments:

Post a Comment