Wednesday, 15 September 2010

php - Insert a plain text list to mysql table -


I have a very long list of plain text, which I need to put in the table in my database, do I manually Is there a way to input each line of your plain text document or is there a way to insert rows in separate rows into a single line using a question query?

I have a table with 2 columns, ID and club_name, Club_name is a list which is plain text in Notepad document.

You can use, eg:

  mysql> ; Load data in local INFILE '/path/pet.txt' table - & gt; Lines determined by '\ r \ n';   

You can also use syntax (if you are using the InDebib table), then this way:

  your eligible values ​​(1 , 2), (5,5), ...    

No comments:

Post a Comment