Delete a record after making a query?

You can create a Stored Procedure in your database. Here's an example:

DELIMITER $$

USE 'database'$$

DROP PROCEDURE IF EXISTS 'consultaMensagem'$$

CREATE PROCEDURE 'consultaMensagem'(IN idMensagem INT)
BEGIN
    SELECT * FROM mensagem WHERE id = idMensagem;   
    DELETE FROM mensagem WHERE id = idMensagem;
END$$
DELIMITER ;

Being:

database - > your database queryMessage - > name of your procedure idMessage - > input parameter for query and deletion

Between BEGIN and END you develop your procedure, in case this executes a query in the database filtering all the records that have the id = idMensagem (parameter passed to the procedure). Then, with the same filter, it executes a DELETE , thus eliminating the queried message.

To execute procedure , do this:

Call consultaMensagem(1);

So the message with id = 1 will be returned and deleted soon.