MySql Update with Inner Join

If you need to run an UPDATE in MySql on some rows in a table, but the reference of the condition to use is in another table, the best solution is to use an UPDATE associated with an INNER JOIN.

Here is an example:

UPDATE users
        INNER JOIN
    users_products ON users_products.user_id = 
    users_products.paid = 1
    DATEDIFF(CURDATE(), users.payment_date) > 1;

Leave a Comment

Your email address will not be published. Required fields are marked *