RE: [PHP] Re-Importing .CSV file into Database
| From: | Rick Emery | Date: | Wed, 13 Feb 2002 17:12:09 +0000 |
| Subject: | RE: [PHP] Re-Importing .CSV file into Database | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-84609@lists.php.net to get a copy of this message | ||
Thomas,
Can you provide your table structure and about a dozen lines from your file?
I'd like to experiment with it on my machine.
We WILL get this resolved...
rick
-----Original Message-----
From: Thomas Edison Jr. [mailto:thomasedisonjr@yahoo.com]
Sent: Wednesday, February 13, 2002 11:09 AM
To: Rick Emery
Cc: php-general@lists.php.net
Subject: RE: [PHP] Re-Importing .CSV file into Database
Oh yes, definately. With the appropriate columns too.
--- Rick Emery <remery@excel.com> wrote:
> Has fanlist_try table been created?
>
> -----Original Message-----
> From: Thomas Edison Jr.
> [mailto:thomasedisonjr@yahoo.com]
> Sent: Wednesday, February 13, 2002 10:54 AM
> To: Jason Murray
> Cc: php-general@lists.php.net
> Subject: RE: [PHP] Re-Importing .CSV file into
> Database
>
>
> Hi,
>
> Ok, considering the FULL PATH and the QUOTES thingy,
> this is the code i'm applying :
>
> <?php
> $db = mysql_connect("localhost","mydb","pwd");
> mysql_select_db("mydb",$db);
>
> $query = "LOAD DATA INFILE 'D:\Apache
>
Group\Apache\htdocs\mjimm\php3\tabledata\fanlist.csv'
> INTO fanlist_try FIELDS TERMINATED BY ',' OPTIONALLY
> ENCLOSED BY '\"' LINES TERMINATED BY '\n' ";
>
> mysql_query($query) or die("error:". mysql_error());
> ?>
>
> And this is the error i'm getting :
>
> error:You have an error in your SQL syntax near
> 'fanlist_try FIELDS TERMINATED BY ',' OPTIONALLY
> ENCLOSED BY '"' LINES TERMINATED' at line 1
>
> So... what's the problem??
>
> Thanks guys, though.
> T. Edison jr.
>
>
>
> =====
> Rahul S. Johari (Director)
> ******************************************
> Abraxas Technologies Inc.
> Homepage : http://www.abraxastech.com
> Email : abraxastech@yahoo.com
> Tel : 91-4546512/4522124
> *******************************************
>
> __________________________________________________
> Do You Yahoo!?
> Send FREE Valentine eCards with Yahoo! Greetings!
> http://greetings.yahoo.com
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
=====
Rahul S. Johari (Director)
******************************************
Abraxas Technologies Inc.
Homepage : http://www.abraxastech.com
Email : abraxastech@yahoo.com
Tel : 91-4546512/4522124
*******************************************
__________________________________________________
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!
http://greetings.yahoo.com