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')
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')