mysql 导出导入测试

最新推荐文章于 2024-06-02 12:16:58 发布

老农民挖数据

最新推荐文章于 2024-06-02 12:16:58 发布

阅读量457

点赞数

分类专栏： MySql 管理与运维文章标签： mysql

本文链接：https://blog.csdn.net/shushugood/article/details/46594727

版权

MySql 管理与运维专栏收录该内容

22 篇文章 1 订阅

订阅专栏

SELECT * INTO OUTFILE '/tmp/cfg_devicetype.txt'
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM lte.cfg_devicetype;

SELECT * INTO OUTFILE '/tmp/cfg_region.txt'
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM lte.cfg_region;

SELECT * INTO OUTFILE '/tmp/cfg_devicemap.txt'
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM lte.cfg_devicemap;

SELECT * INTO OUTFILE '/tmp/cfg_devices.txt'
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM lte.cfg_devices;

LOAD DATA LOCAL INFILE '/tmp/cfg_devicetype.txt' INTO TABLE lte_hbase.cfg_devicetype
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'

LOAD DATA LOCAL INFILE '/tmp/cfg_region.txt' INTO TABLE lte_hbase.cfg_region
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'

LOAD DATA LOCAL INFILE '/tmp/cfg_devices.txt' INTO TABLE lte_hbase.cfg_devices
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'

LOAD DATA LOCAL INFILE '/tmp/cfg_devicemap.txt' INTO TABLE lte_hbase.cfg_devicemap
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'