OR, if you are good at vi, you can insert a ' at the begining and end of every line (if you dont have any 's in the file) then put a , at the end of every odd line then join every other line
the put a "insert into blah (question, answer) values ( " at the begin of every line and then a ");" at the end of every line Then you hopefully have a file full of insert statements and you can just feed it into a mysql client. If I missed a step or added one by accident or even got one wrong, go ahead and fix it and pretend I told you correctly. ;-) The problem with my solution, is that if you have any wierd characters, they arent escaped. or you could just write a perl program chris -----Original Message----- From: gerald_clark [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 8:21 AM To: O.S. Bos Cc: [EMAIL PROTECTED] Subject: Re: Textfile to a 2 column mysql database Write a quick perl program. O.S. Bos wrote: >Hi there, > >I have a textfile that I want to get inserted into a database. The >textfile consists of Questions and Answers. 1st line is a question. 2nd >line of the textfile is the answer. And so on... > >What is the best way to import these lines into the database with 2 >columns. 1 column for the questions and one for the answers? > >Thx! >Unox > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
