insert into test.b (id) (select (id) from a) 转载于:https://www.cnblogs.com/passer1991/archive/2013/04/13/3018628.html