如何使用 LOAD CSV 查看 CSV 文件的列头
如果有一个内容如下的 CSV 文件
id,name,dob,addr1,addr2,city,state,country
1,Joe Smith,04/23/1971,121 Main Street,San Mateo,CA,USA
2,Bill Williams,09/21/2008,43 Overlook St,San Mateo,CA, USA
如果只是想运行一个 LOAD CSV
命令来获取列头,下面的命令就足够了
load csv with headers from 'file:///test.csv' as row with row limit 1 return keys(row);
这将返回类似于以下的输出
+---------------------------------------------------------------------+ | keys(row) | +---------------------------------------------------------------------+ | ["country", "addr2", "city", "addr1", "dob", "name", "state", "id"] | +---------------------------------------------------------------------+
此页面有帮助吗?