MYSQL update a table based on another table's data

Question

I have 2 MySQL tables like these

1. Table main

| email | bounce | status |

2. Table bounce

|email |

what i want is a query to update the (bounce and status column) main table with respect to the data from bounce table

this is the query i tried, update main inner join bounce on (main.email = bounce.email) set main.bounce='yes' and main.status='Inactive';

question from:https://stackoverflow.com/questions/65847020/mysql-update-a-table-based-on-another-tables-data

Answer 1

You should try

UPDATE main m
INNER JOIN bounce b
ON m.email=b.email
SET m.bounce="yes" AND m.status="Inactive";