Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
DELIMITER // CREATE PROCEDURE SafeInsertUser(IN p_email VARCHAR(255)) BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN ROLLBACK; SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'User insert failed, transaction rolled back'; END; START TRANSACTION; INSERT INTO users (email, created_at) VALUES (p_email, NOW()); COMMIT; END // DELIMITER ;
Result
Open