Syntax Error with Begin or Start transaction in Query Builder

[ad_1]

The following query gives a syntax error in the query builder, while when I run this in phpmyadmin it works fine.

START TRANSACTION;
INSERT INTO wp_4_frm_items (item_key, form_id, post_id, user_id, parent_item_id, is_draft, updated_by, created_at, updated_at)
SELECT guid, 3 as form_id, 0 as post_id, 1 as user_id, 0 as parent_item_id, 0 as is_draft, 1 as updated_by, Now() as created_at, Now() as updated_at FROM reparaturo_repair_status
ON DUPLICATE KEY
UPDATE id=id;
COMMIT;

The page I need help with: [log in to see the link]

 

This site will teach you how to build a WordPress website for beginners. We will cover everything from installing WordPress to adding pages, posts, and images to your site. You will learn how to customize your site with themes and plugins, as well as how to market your site online.

Buy WordPress Transfer