Re: Bulk Insert from text file

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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/


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux