示例
建表语句:
CREATE TABLE data_test (column_1 INT, column_2 VARCHAR(50),
column_3 VARCHAR(20), column_4 VARCHAR(10));
数据文件:
123|eqwerqwee|asdfsacq|adfasdfaa
234|qreqwerqw|sfwrwers|asfdasdfa
435|asdfsfadfasf|werqqws|asdfasfds
765|ertyertyeref|fdwaesws|sfgwerwr
加载过程:
gbase>LOAD DATA INFILE ‘http://192.168.6.39/test.tbl’ INTO TABLE
data_test FIELDS TERMINATED BY ‘|’ IGNORE 3 LINES;
Task 26 finished, Loaded 1 records, Skipped 0 records
查询入库数据:
gbase> SELECT * FROM test.data_test;
+------+-----------+----------+-----------+
|column_1 | column_2 | column_3 | column_4 |
+------+-----------+----------+-----------+
|
765 | ertyertyeref | fdwaesws | sfgwerwr |
1 row in set