mysql: select, insert, delete and update in one query

Question

i need in one query use select, insert, delete and update.

(I need copy data from old table in to new, then delete old, and update another).

Insert and select (copy function I was able to, but now i have problem)

I have this query:

INSERT INTO news_n (id, data)
    SELECT (id, data)
    FROM news
    WHERE id > 21

Thanks

Answer 1

You can't do it all in one query, but you can do it all in one transaction if you are using a transactional store engine (like InnoDB). This might be what you want, but it's hard to tell only using the information you provided in your question.

START TRANSACTION;

INSERT...;
DELETE...
UPDATE...;

COMMIT;