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, [EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php