求mysql数据库中创建触发器禁止插入数据库 的语句

Question

 

Answer 1

CREATE TRIGGER tri_account
    AFTER INSERT ON account
    FOR EACH ROW
    if LENGTH(NEW.user_password)<6 then
	begin
		ROLLBACK TRANSACTION
	end if