LOAD DATA LOCAL INFILE '/tmp/phpFBsb3v' REPLACE INTO TABLE agents FIELDS
TERMINATED BY ',' OPTIONALLY ENCLOSED BY ''' LINES TERMINATED BY '\n'
(agent_id,first_name,last_name,email_address,area_code,area,have_picture,abo
ut)
anybody see anything wrong in this ??? I've also tryed '\r' and '\r\n' for
line termination.
I'm using phpmyadmin 2.2.0rc3 with MySql 3.22.32
Heres a sample of my text file:
'9805','JEANNIE','ANDERSON','[EMAIL PROTECTED]','
AR','Arlington',1,'Jeannie AndersonPrudential Network Realty2771-7 Monument
Rd.Jackso'
'1904','BILL','BACALIS','[EMAIL PROTECTED]','AR','Arl
ington',0,'Bill BacalisWhen'
'10730','CHERYL','BISTRICKY','[EMAIL PROTECTED]',
'AR','Arlington',0,
'1890','JULIA','BLANTON','[EMAIL PROTECTED]','AR','A
rlington',0,' Julia Blanton Education Graduate New Hanover High School,
Wilmington, NC Community College, Ala'
'9311','BOB','DANGOIA','[EMAIL PROTECTED]','AR','Arlin
gton',1,'Bob Dangoia, CSP, CSA IIBus'
'3516','JOANNE','DOHERTY','[EMAIL PROTECTED]','AR',
'Arlington',1,'JoAnne Doherty, ABR, CRS, GRIFocused on ServiceLicensed
Broker'
'1945','CONNIE','GLENN','[EMAIL PROTECTED]','AR','Arl
ington',0,'Connie Glenn Education BS in History, Ed. - Trevecca Nazarene
Univeristy, Nashville, TN Graduate F.C.C.J. - Real Estate Licensing'
---------------------------------------------------------------------
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
