|
|
 |
RE: FN-FORUM Mysql "load data infile" problem
date posted 4th December 2002 14:47
What the hell....
Looked out the example anyway..
$sql="LOAD DATA LOCAL INFILE 'G:/Program
Files/nusphere/apache/htdocs/rowan/property.txt' INTO TABLE property
FIELDS TERMINATED BY '|' LINES TERMINATED BY '
'";
$result = mysql_query($sql) or die( mysql_error());
---
www.galcomp.net - Full Featured Web hosting
www.cvdb.info - Free CV storage and autoresponder
-----Original Message-----
From: [EMAIL REMOVED]
[EMAIL REMOVED] On Behalf Of Raymond Stone
Sent: 04 December 2002 14:22
To: [EMAIL REMOVED]
Subject: RE: FN-FORUM Mysql "load data infile" problem
Importance: High
I recently helped someone at phpbuilder with this same problem.
Their problem was that windows required the file spec in a particluar
format. If you are still stuck by the time you read then then send me an
email and I will dig out the working code.
---
www.galcomp.net - Full Featured Web hosting
www.cvdb.info - Free CV storage and autoresponder
-----Original Message-----
From: [EMAIL REMOVED]
[EMAIL REMOVED] On Behalf Of Rene Docherty
Sent: 04 December 2002 11:49
To: freelancers
Subject: FN-FORUM Mysql "load data infile" problem
Hi,
Im using a windows version of Mysql and am finding that the following
upload command is not working :
load data infile 'out.csv' into table outfile fields terminated by ','
lines terminated by '
';
Im trying to upload a CSV file into the Db but the above command keeps
throwing a syntax error. Anyone know why it could be doing this? Could
it be a "windows" thing? The example on the documentation looks exactly
the same???
Cheers,
René Docherty
Professional Web Developer
--------------------------------
T : 01324 877763
E : [EMAIL REMOVED]
W : http://www.ecoder.co.uk
========
Advertise with Freelancers.net +Additions+
http://www.freelancers.net/advert.php
Freelancers and Freelance Jobs:
http://www.freelancers.net
Forum FAQs:
http://freelancers.netrickery.com
To unsubscribe please email:
[EMAIL REMOVED]
If you have difficulties unsubscribing please email:
[EMAIL REMOVED]
========
Advertise with Freelancers.net +Additions+
http://www.freelancers.net/advert.php
Freelancers and Freelance Jobs:
http://www.freelancers.net
Forum FAQs:
http://freelancers.netrickery.com
To unsubscribe please email:
[EMAIL REMOVED]
If you have difficulties unsubscribing please email:
[EMAIL REMOVED]
|
|
|
