How to insert a list from a text file into mysql table ?

Posted on by

I wish to insert a list of names from a content record (or csv), in to a mysql list which has some-more columns . we usually wish to deliver a names in a second mainstay of a list withdrawal all alternative fields default.

One thought on “How to insert a list from a text file into mysql table ?”

  1. Use the LOAD DATA INFILE command. I’m not familiar with it enough to give you an example, but it should do what you need.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>