#1093 - You can't specify a target table for update in FROM clause

[r1ch]

Hi,

I am currently getting the error "#1093 - You can't specify target table 'bookings' for update in FROM clause" when trying to run the below query.

Any help would be much appreciated!

Many thanks in advance for your time.

Richard

BEGIN;
INSERT INTO users (firstname, lastname, dob, email, mobile, uni, address, postcode) 
VALUES (firstname, lastname, 1980-10-10, email, mobile, 1, address, postcode);
INSERT INTO bookings (eid, tid, pid, uid, value) 
VALUES (4, 2,
(SELECT pid FROM promoters, tickets WHERE promoters.id = tickets.pid AND 2 BETWEEN start AND end AND eid = 4), 
(SELECT users.id AS uid FROM users  WHERE users.reg_date IN (SELECT bookings.reg_date FROM bookings)),  12);
COMMIT;

[longneck]

well, you can't SELECT from the same table you're trying to INSERT in to when using the INSERT ... VALUES construct.

an easy way around this problem is to rewrite the VALUES clause into a SELECT statement instead. see http://dev.mysql.com/doc/refman/5.1/...rt-select.html