Hi
Could any 1 please help on how to insert using phpMyAdmin??
I haven't used phpMyAdmin in years, but here's how I'd do it in SQL with
my favourite tool (SQLyog)
LOAD DATA LOCAL INFILE 'C:\file_name.txt'
INTO TABLE tbl_name
FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\n'
IGNORE 1
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
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 = ',')