建表语句:
create table t (i int, vc varchar(10), dt datetime default '2000-01-01 00:00:01', d
t1 datetime default '2000-01-01 00:00:01');
数据文件:
GBase UP 产品手册 5 数据库管理指南
文档版本04(2021-04-21) 南大通用数据技术股份有限公司 225
31589,E,02:02:02 2094-12-13,2082-12-24 01:01:01
16993,jcWaz,02:02:02 2060-10-22,2037-11-17 01:01:01
7584,jubNKAmT,02:02:02 2058-12-24,2066-11-26 01:01:01
8698,iOStkY,02:02:02 2024-11-17,2064-10-25 01:01:01
23256,itWsHqL,02:02:02 2069-10-24,2021-11-19 01:01:01
21932,GelDJbuE,02:02:02 2017-11-26,2075-11-19 01:01:01
4859,Gl,02:02:02 2040-10-16,2051-10-25 01:01:01
11751,InTUcdIM,02:02:02 2048-12-23,2099-10-26 01:01:01
8487,JZ,02:02:02 2026-12-13,2084-11-15 01:01:01
3693,lEKyI,02:02:02 2063-10-21,2026-11-20 01:01:01
加载过程:
gbase> load data infile 'ftp://192.168.88.141/load_data/table_fields.tbl' into tab
le test.t fields terminated by ',' table_fields 'i, vc, dt date "%H:%i:%s %Y-%m-%d
", dt1 date "%Y-%m-%d %H:%i:%s"';
Query OK, 10 rows affected, 0 warnings
Task 1114 finished, Loaded 10 records, Skipped 0 records
查询入库数据:
gbase> select * from test.t;
+-------+----------+---------------------+---------------------+
| i | vc | dt | dt1 |
+-------+----------+---------------------+---------------------+
| 23256 | itWsHqL | 2069-10-24 02:02:02 | 2021-11-19 01:01:01 |
| 31589 | E | 2094-12-13 02:02:02 | 2082-12-24 01:01:01 |
| 8487 | JZ | 2026-12-13 02:02:02 | 2084-11-15 01:01:01 |
| 21932 | GelDJbuE | 2017-11-26 02:02:02 | 2075-11-19 01:01:01 |
| 16993 | jcWaz | 2060-10-22 02:02:02 | 2037-11-17 01:01:01 |
| 3693 | lEKyI | 2063-10-21 02:02:02 | 2026-11-20 01:01:01 |
| 11751 | InTUcdIM | 2048-12-23 02:02:02 | 2099-10-26 01:01:01 |
| 8698 | iOStkY | 2024-11-17 02:02:02 | 2064-10-25 01:01:01 |
| 4859 | Gl | 2040-10-16 02:02:02 | 2051-10-25 01:01:01 |
| 7584 | jubNKAmT | 2058-12-24 02:02:02 | 2066-11-26 01:01:01 |
+-------+----------+---------------------+---------------------+
10 rows in set