sql 多表合并

Question

有多张表，他们的列都是相同的，存储的内容没有相同的，就是将多张表合起来，如下
     tb1:         name            number           sex
                  aa                  1             1
                  bb                  1             2
                  cc                  1             1
     tb2:        name            number           sex
                  dd                  2             1
                  ee                  2             2
     tb3:        name            number           sex
                  ff                  3             1
                  gg                  3             2
      .......
  合并结果
    tb           name            number           sex
                  aa                  1             1
                  bb                  1             2
                  cc                  1             1
                  dd                  2             1
                  ee                  2             2
                  ff                  3             1
                  gg                  3             2
                  .......   只是简单的合并，不用考虑合并条件
       

Answer 1

insert into tb values(select * from tb1)
这样写试试看 

Answer 2

select * from tb1
union all
select * from tb2
union all
select * from tb3

Answer 3

insert into tb values(select * from tb1,tb2,tb3)

Answer 4

select * from tb1
union all
select * from tb2
union all
select * from tb3