MySQL: Insert into multiple tables in same query with BEGIN&COMMIT

Question

I want to insert into multiple tables in same query by using BEGIN and COMMIT. It seems the error occur at begin.

here is my SQL command

    BEGIN
    INSERT INTO Product (pName, pBrand, pCategory, pSize, pQuantity, pPrice, pDetail)
        VALUES('$name', '$brand', '$category', '$size', '$quantity', '$price', '$detail')
    INSERT INTO Image (iName, iExt, iSize, pID)
        VALUES('$img_name', '$img_ext', '$img_size', LAST_INSERT_ID());
    COMMIT;

John Woo · Accepted Answer · 2012-09-29 03:41:01Z

5

you forgot to add semicolon ; (or the terminator) after the keyword BEGIN

See SQLFiddle Demo

edited Sep 29, 2012 at 3:41

answered Sep 29, 2012 at 3:35

John Woo

265k70 gold badges509 silver badges500 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL: Insert into multiple tables in same query with BEGIN&COMMIT

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related