1. 说明
DATA_FORMAT指定为4,表示使用定长方式加载。如果某列数据可能包含了行分隔符,则需要在SQL中输入'HAVING LINES SEPARATOR'子句。
2. 使用语法
LOAD DATA INFILE 'file_list' INTO TABLE [dbname.]tbl_name DATA_FORMAT 4 [options];
3. 使用示例
- 建表语句
create table t (i int, vc varchar(10), c char(10));
- 数据文件内容
099121413321565086687636597553
587231374843706182211816625391
371909169687901865998438248540
768084517620945445680375033918
521019961269855481454503093679
872098120283548973190459767139
047458772732776053730815273248
749195982779059832391367570454
773781140773581380240166238167
733086147402918352113773075709
- 加载过程
gbase> load data infile 'ftp://192.168.88.141/load_data/definer.tbl' into table test.t data_format 4 fields length'1,10,10';
Query OK, 10 rows affected
Task 1128 finished, Loaded 10 records, Skipped 0 records</