mysql - deleting from two tables in one query

Question

Who can help me make the following query work...

Both tables have the fields month, year and userId. And I want to delete rows in both Tables for the exact same values for month and year.

DELETE FROM Table1, Table2 WHERE Table1.month NOT IN (1,2) AND Table1.year NOT IN (1, 2) AND Table1.userId = 1 AND Table2.userId = Table1.userId

Thanks.

Amber · Accepted Answer · 2012-03-24 17:09:56Z

4

DELETE FROM Table1, Table2
USING Table1, Table2
WHERE Table1.month NOT IN (1,2)
  AND Table1.year NOT IN (1, 2)
  AND Table1.userId = 1
  AND Table2.userId = Table1.userId

http://dev.mysql.com/doc/refman/5.5/en/delete.html

answered Mar 24, 2012 at 17:09

Amber

531k89 gold badges643 silver badges558 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

mysql - deleting from two tables in one query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related