*百万级别的数据导入**
1不通过代码层面去导入和导出数据:通过sql语句:具体sql如下
select * into OUTFILE 'D:\\product.txt' from product_info
load data INFILE 'D:\\product.txt' into table product_info2
create TABLE proeduct_info2 select * from product_info