Delete from two tables in one query

Question

I have two tables in MySQL

#messages table :
messageid
messagetitle
.
.

#usersmessages table
usersmessageid
messageid
userid
.
.

Now if I want to delete from the message table I can. But when I delete the message by messageid, the record still exists on usersmessage and I have to delete from both tables immediately.

I used the following query:

DELETE FROM messages LEFT JOIN usersmessages USING(messageid) WHERE messageid='1' ;

Then I test

DELETE FROM messages , usersmessages
   WHERE messages.messageid = usersmessages.messageid
   and messageid='1' ;

But these two queries did not complete the task.

Answer 1

DELETE a.*, b.* 
FROM messages a 
LEFT JOIN usersmessages b 
ON b.messageid = a.messageid 
WHERE a.messageid = 1

Translation: Delete from table messages, where messageid = 1, if table uersmessages has messageid = messageid of table messages, then delete the rowUser message table.

Answer 2

Can't they be separated by semicolons?

Delete from messages where messageid = '1';
Delete from usersmessages where messageid = '1'

or

Just use INNER JOIN as shown below

DELETE messages , usersmessages  FROM messages  INNER JOIN usersmessages  
WHERE messages.messageid= usersmessages.messageid and messages.messageid = '1'