根据查询结果,插入记录
例如:
insert into T_MealOrder (UserID,Price,Quantity,MealType,TakeType,CreatUserID)
(Select UserID,Price,Quantity,MealType,TakeType,CreatUserID FROM T_MealOrderAuto Where Flag<>0)
insert into T_MealOrder (UserID,Price,Quantity,MealType,TakeType,CreatUserID)
(Select UserID,Price,Quantity,MealType,TakeType,CreatUserID FROM T_MealOrderAuto Where Flag<>0)