【单选题】给定如下代码: CREATE TABLE tb_account(num INT, amount DECIMAL(10,2)); CREATE TRIGGER tr_acct AFTER INSERT ON tb_account FOR EACH ROW SET @sum=@sum+NEW.amount; 表和触发器成功创建后,执行如下命令: SET @sum=0.00; INSERT INTO t...
【简答题】给定如下代码: CREATE TABLE tb_account(num INT,amount DECIMAL(10,2)); CREATE TRIGGER tr_acct AFTER INSERT ON tb_account FOR EACH ROW SET@sum=@sum+NEW.amount; 表和触发器成功创建后,执行如下命令: SET@sum=0.00; INSERT INTO tb_a...