建表语句:
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 te
st.t data_format 4 fields LENGTH '1,10,10';
Query OK, 10 rows affected
Task 1128 finished, Loaded 10 records, Skipped 0 records
查询入库数据:
gbase> select * from t;
+------+------------+------------+
| i | vc | c |
+------+------------+------------+
| 3 | 7190916968 | 7901865998 |
| 0 | 4745877273 | 2776053730 |
| 0 | 9912141332 | 1565086687 |
GBase UP 产品手册 5 数据库管理指南
文档版本04(2021-04-21) 南大通用数据技术股份有限公司 227
| 7 | 7378114077 | 3581380240 |
| 5 | 8723137484 | 3706182211 |
| 7 | 3308614740 | 2918352113 |
| 7 | 6808451762 | 0945445680 |
| 5 | 2101996126 | 9855481454 |
| 8 | 7209812028 | 3548973190 |
| 7 | 4919598277 | 9059832391 |
+------+------------+------------+
10 rows in set