日期:2014-05-17 浏览次数:21056 次
"ID","EMAIL","PASSWORD","CONFPASSOWRD","SEX","USERNAME" "206","zhangshaoqi55@163.com","86847wse","86847wse","2","杨雪莲" "207","zhangzifang.happy@163.com","6741s2yi","6741s2yi","0","宋春雨" "156","xiebaxing@sina.com","leisqiang","leisqiang","2","王颖" "157","zhaoyilun@yahoo.cn","821s155","8211s55","2","林格格"
OPTIONS (skip=1,rows=5) -- sqlldr 命令显示的选项可以写到这里边来,skip=1 用来跳过数据中的 LOAD DATA INFILE "g://12.csv" --指定外部数据文件,可以写多个 INFILE "another_data_file.csv" 指定多个数据文件 append INTO TABLE xgs_register Fields terminated by "," -- 数据中每行记录用 "," 分隔 Optionally enclosed by '"' -- 数据中每个字段用 '"' 框起,比如字段中有 "," 分隔符时 trailing nullcols --表的字段没有对应的值时允许为空 ( id number, EMAIL VARCHAR2(100),--邮箱 PASSWORD VARCHAR2(300),--密码 EMAILPASSOWRD VARCHAR2(30),--邮箱密码 SEX number,--性别 USERNAME VARCHAR2(30)--用户名 )