Having issues realizing why this doesn’t work? The error i get is a standard can’t do this..
error -> MySQL server version for the right syntax to use near ‘DELETE FROM industry_manager WHERE category_id = 123456; INSERT INTO industry_m’ at line 1
The query is as follows on a mysql 5.7 server, i do have an old mysql client (50012 i think?) for the php side. However, if i paste this into phpmyadmin, it works? is it just a mysqli-client issue?

START TRANSACTION;

DELETE FROM industry_manager WHERE industry_id = 123456;

INSERT INTO industry_manager (id, version, industry_id, manager_id)
VALUES ((SELECT value FROM _opt WHERE name = 'id'), 1, 123456, 980);

UPDATE optional SET value = value + 1 WHERE tables = 'id';

COMMIT;

Any pointers would be greatly appreciated!