CODEWITHSUNDEEP
sqlmysql
rosan
rosan

Reputation: 101

Inserting a list to mysql

Hai, there, i got this huge list 5k in notepad delimited with new line, i want to insert this to a mysql table is there a way to do that, like a single query or like a antomated way to generate INSERT into bla bla bla..for all of them?

Upvotes: 0

Views: 216

Answers (1)

rkg
rkg

Reputation: 5719

Check the following link on how to import data into MySQL from a flat file: http://dev.mysql.com/doc/refman/4.1/en/mysqlimport.html

There are also some fancy applications which can help you do this like SQLYog

Upvotes: 2

Related Questions