Bulk Insert from text file
| From: | Nasreen Laghari | Date: | Tue, 23 Sep 2008 20:25:30 +0000 |
| Subject: | Bulk Insert from text file | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-45449@lists.php.net to get a copy of this message | ||
Hi All,
I have bulk data store in text file, which is attached with this email. 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 = '","')
Any help will be appreciated.
Regards,
Nasreen