mysql 触发器 AFTER DELETE求助

Question

CREATE DEFINER=`root`@`localhost` TRIGGER `A_AFTER_DELETE` AFTER DELETE ON `A` FOR EACH ROW BEGIN
     insert A(name)  select old.name;
END

为何报错，删除的同时不允许写入数据？？？？？？？

Answer 1

你这个创建触发器的语句怎么感觉怪怪的。