Transaction Query
Copy Below Code
View As A Text File
Show Text Only
Show API
Edit Code
START TRANSACTION;
INSERT INTO employee (fname,lname) VALUES ('waq', 'ham');
SELECT @id:=LAST_INSERT_ID();
INSERT INTO employee_logs (emp_id,dated) VALUES (@id, CURDATE());
COMMIT;