List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:May 10 2001 4:17am
Subject:RE: RE: AIX recommendations
View as plain text  
At 9:11 AM -0400 5/9/01, Terry Shipclark wrote:
>database,sql,query
>
>Why does this statement not work????

Because you're either not reading the manual or ignoring what it says?

>
>LOAD DATA INFILE 'intervext.txt' into table intvext
>(intid,priphone,cellphone,pager,bdmonth,bdday,datehired,Notes)
>	FIELDS TERMINATED BY ';'
>	ENCLOSED BY '"'
>	LINES TERMINATED BY '\n';

According to the manual, the column list follows the FIELDS/LINES
specifiers.

>
>I also tried it like this
>
>LOAD DATA INFILE 'intervext.txt' FIELDS TERMINATED BY ';'
>	ENCLOSED BY '"'
>	LINES TERMINATED BY '\n'
>	into table intvext
>(intid,priphone,cellphone,pager,bdmonth,bdday,datehired,Notes);

According to the manual, the FIELDS/LINES specifiers follow the
table specifier.

>
>it worked like this,
>
>LOAD DATA INFILE 'intervext.txt'
>	into table intvext
>(intid,priphone,cellphone,pager,bdmonth,bdday,datehired,Notes);
>
>Help, tell me what I am doing wrong


-- 
Paul DuBois, paul@stripped
Thread
RE: RE: AIX recommendationsTerry Shipclark9 May
  • RE: RE: AIX recommendationsPaul DuBois10 May