Re: Bulk Insert from text file

From:	Chris	Date:	Thu, 25 Sep 2008 02:37:38 +0000
Subject:	Re: Bulk Insert from text file
References:	1	Groups:	php.db
Request:	Send a blank email to php-db+get-45455@lists.php.net to get a copy of this message

Nasreen Laghari wrote:

Hi All, I have bulk data store in text file, which is attached with this email.

Attachments never come through to the php mailing list(s). If anyone asks for an attachment, place it somewhere on a website and provide a link. Could any 1 please help on how to insert using phpMyAdmin??

I tried using below code but getting "Error in SQL Syntax": BULK
INSERT venue  FROM 'c:\venues.txt'             WITH
    (   FIELDTERMINATOR = '","')

http://dev.mysql.com/doc/refman/5.0/en/load-data.html -- Postgresql & php tutorials http://www.designmagick.com/