clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2249313 fiddles created (32225 in the last week).

CREATE TABLE bookings(ID int AUTO_INCREMENT PRIMARY KEY,unique_id int, branch_id int, pos_user_id int, user_id int, user_address_id int)
 hidden batch(es)


CREATE TABLE bookings_clone(ID int ,unique_id int, branch_id int, pos_user_id int, user_id int, user_address_id int)
 hidden batch(es)


CREATE TRIGGER after_booking_inserted AFTER INSERT ON bookings FOR EACH ROW BEGIN INSERT INTO bookings_clone select * from bookings where id = NEW.id; END;
 hidden batch(es)


INSERT INTO bookings VALUES(NULL,13,13,13,13,13)
 hidden batch(es)


SELECT * FROM bookings_clone
ID unique_id branch_id pos_user_id user_id user_address_id
1 13 13 13 13 13
 hidden batch(es)