Error in SQL query

[Robin John]

I am a newbie in Database. I am trying to understand the working of MySQL Workbench by trying to manipulate a few databases.

To do so I am first learning to manipulate two tables in one database. To do so I wrote the following query.

DECLARE status_post INT DEFAULT 0
START TRANSACTION;
INSERT INTO wp_text (Id, Titel, Inleiding, Tekst, Datum)
SELECT Id, Titel, Inleiding, Tekst, Datum
FROM teksten;

SELECT Active from teksten INTO status_post;

IF status_post = 1 THEN
INSERT INTO wp_text (Active) (`publish`);
ELSE
INSERT INTO wp_text (Active) (`pending`);
COMMIT;
END IF;

But obviously there is a syntax error. I tried to search it online but all in vain. Can anyone guide me into the right direction and tell me what am I doing wrong?

Thanks in advance.

Robin