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
database,sql,query
Why does this statement not work
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';
I also tried it like this
LOA