How to import csv in mysql

Question

User1805528910 posted

Can anyone help me how to import csv in mysql?

I have large database file which i want to import it in to msyql database.

Is it directly possible to import it?

Please help

Answer 1

User-269404413 posted

hemant,

try this

load data local infile 'uniq.csv' into table tblUniq
fields terminated by ','
enclosed by '"'
lines terminated by '\n'
(uniqName, uniqCity, uniqComments)

refer this page also here is an complete description

Answer 2

User-843484705 posted

Here is easy five step to import csv file in mySql

http://blog.tjitjing.com/index.php/2008/02/import-excel-data-into-mysql-in-5-easy.html

happy coding