MySQl 合并结构相同的多张表

CREATE TABLE goods_xinxi
        select * from goods_xinxi_0
        UNION ALL
        select * from goods_xinxi_1
        UNION ALL
        select * from goods_xinxi_2
        UNION ALL
        select * from goods_xinxi_3
        UNION ALL
        select * from goods_xinxi_4
        UNION ALL
        select * from goods_xinxi_5
CREATE TABLE goods_xinxi
        select * f