order_other id 主键 hand_phone ‘order_main’表的tel order_id order_main’表的id module_type
------解决方案-------------------- CREATE TRIGGER t1 AFTER INSERT ON `order_main` FOR EACH ROW INSERT INTO `order_other` (`hand_phone`,`id`,`module_type`) VALUES (NEW.tel,NEW.`id`,'Book') or CREATE TRIGGER t1 AFTER INSERT ON `order_main` FOR EACH ROW INSERT INTO `order_other` (`hand_phone`,`id`,`module_type`) VALUES (NEW.tel,last_insert_id(),'Book')
------解决方案--------------------