locked
How to import csv in mysql RRS feed

  • 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

    Saturday, June 18, 2011 4:36 AM

Answers

  • 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

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Saturday, June 18, 2011 5:21 AM

All replies