create trigger copy_product AFTER insert ON product for each row
begin
set @type_name1=new.type_name;
set @product_name1=new.product_name;
set @price1=new.price;
set @number1=new.number;
set @flag1=new.flag;
insert into product1 values(type_name1,product_name1,price1,number1,flag1);
end;
当本人向product表中插入数据时显示[Err] 1054 – Unknown column “type_name1” in “field list”,刚接触mysql不久,求高手帮忙!
begin
set @type_name1=new.type_name;
set @product_name1=new.product_name;
set @price1=new.price;
set @number1=new.number;
set @flag1=new.flag;
insert into product1 values(type_name1,product_name1,price1,number1,flag1);
end;
当本人向product表中插入数据时显示[Err] 1054 – Unknown column “type_name1” in “field list”,刚接触mysql不久,求高手帮忙!
解决方案
40
@type_name1 前的@没有了。