【达梦】DCP题目解析（实操5）

# cat /opt/emp.txt
--id,name,birthday
1,a,2019-01-01
2,b,2018-08-08
3,c,1998-10-10
4,d,1988-11-11

方法一：

# cd /opt
# vi emp.ctl

LOAD DATA
INFILE '/opt/emp.txt'
INTO TABLE DMTEST.EMP
FIELDS ','

# chown dmdba:dinstall emp.txt emp.ctl
# su - dmdba
$ disql DMTEST/DMTEST123:5236

SQL> create external table DMTEST.EMP(ID INT, NAME VARCHAR(20), BIRTHDAY DATE) from '/opt/emp.ctl';

方法二：

$ disql sysdba/DM01SYSDBA:5236

SQL> create external table DMTEST.EMP(ID INT, NAME VARCHAR(20), BIRTHDAY DATE) from datafile '/opt/emp.txt' parms (fields delimited by ',', skip 1, character_code 'utf-8');

检查：

SQL> DESC DMTEST.EMP
行号 NAME TYPE$ NULLABLE
---------- -------- ----------- --------
1 ID INTEGER Y
2 NAME VARCHAR(20) Y
3 BIRTHDAY DATE Y
SQL> select * from DMTEST.EMP;