INSERT t1, SELECT t2, UPDATE t2 through single MySQL Query

CREATE DATABASE AND TABLES AND INSERT.

CREATE DATABASE IF NOT EXISTS stackoverflow;

DROP TABLE IF EXISTS stackoverflow.t1;

CREATE TABLE stackoverflow.t1(
 id INT
);


DROP TABLE IF EXISTS stackoverflow.t2;

CREATE TABLE stackoverflow.t2 (
    id INT
  , STATUS INT
);

INSERT INTO stackoverflow.t2 (id, STATUS) VALUES (1, 0);


CREATE PROCEDURE.

DROP PROCEDURE IF EXISTS stackoverflow.select_from_t2;

DELIMITER $$

CREATE
    PROCEDURE stackoverflow.select_from_t2(
      lookup_id INT
    )

    BEGIN

           /* UPDATE status in t2 */
           UPDATE
             stackoverflow.t2
           SET
             stackoverflow.t2.STATUS = 1
           WHERE
              stackoverflow.t2.id = lookup_id;

      /* Copy the t2 record into t1 table */
      INSERT INTO
       stackoverflow.t1
      (stackoverflow.t1.id)
      SELECT
       id
      FROM
       stackoverflow.t2
      WHERE
        stackoverflow.t2.id = lookup_id;



    END$$

DELIMITER ;


How TO USE PROCEDURE.

CALL stackoverflow.select_from_t2(1);

Results

Query

SELECT * FROM t1;

RESULT

    id
--------
       1


query

SELECT * FROM t2;

RESULT

    id  STATUS
------  --------
     1         1