您可以使用INSERT … SELECt语法。请注意，您可以在SELECT部分中直接引用“ 1”。
INSERT INTO mt_magazine_subscription ( magazine_subscription_id, subscription_name, magazine_id, status ) SELECT magazine_subscription_id, subscription_name, magazine_id, '1'FROM tbl_magazine_subscriptionORDER BY magazine_subscription_id ASC
