CODEWITHSUNDEEP
csv
shanmugavel
shanmugavel

Reputation: 15

bulk insert into mysql (CSV file-Codeigniter)

I need function or code for bulk insert categories into mysql database.I am using codeigniter for my project.

Upvotes: 1

Views: 1492

Answers (1)

Mike Valstar
Mike Valstar

Reputation: 3519

START TRANSACTION;

DELETE FROM `mytable`;

LOAD DATA INFILE '/var/www/something.csv'
INTO TABLE `mytable`
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY ''
LINES TERMINATED BY '\r\n'
(email, login, pass)

COMMIT;

this can be run directly in mysql to import data from a CSV

Upvotes: 1

Related Questions