How to delete from three or more mysql tables by one id?

Question

MySQL

For removal I use request from the documentation.

DELETE FROM userdata, moneys, user_roles USING userdata INNER JOIN moneys INNER JOIN user_roles WHERE userdata.userid=525300849082105856 AND moneys.userid=525300849082105856 AND user_roles.userid=525300849082105856;

But a difficulty arises when one of the tables has no records with this userid, and the query does not delete any records in other tables.
Tell me how to change the request.

Answer 1

DELETE 
FROM userdata, moneys, user_roles 
USING ( SELECT 525300849082105856 userid ) criteria
LEFT JOIN userdata USING (userid)
LEFT JOIN moneys USING (userid)
LEFT JOIN user_roles USING (userid);

Answer 2

and left join?
According to the right way, when creating a foreign key index, you need to specify on delete cascade, and then when you delete a record in the main table, all related records will be deleted automatically