mycat1.6使用案例----load data file使用示例（ER分片字表数据导入）
日期： 2017-04-27 分类： 跨站数据测试 283次阅读
1、mysql提供了高效的数据导入命名 load data infile:
基本语法：
load data [low_priority] [local] infile 'file_name txt' [replace | ignore]
into table tbl_name
[fields
[terminated by't']
[OPTIONALLY] enclosed by '']
[escaped by'\' ]]
[lines terminated by'n']
[ignore number lines]
[(col_name, )]
into table tbl_name
[fields
[terminated by't']
[OPTIONALLY] enclosed by '']
[escaped by'\' ]]
[lines terminated by'n']
[ignore number lines]
[(col_name, )]
精华推荐