ires feeding in MySQL afterwards and
it disregards special characters.
Lian
> -Original Message-
> From: gerald_clark [mailto:[EMAIL PROTECTED]
> Sent: Monday, June 23, 2003 4:42 PM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: Textfile to a 2 column mysql databas
gerald_clark wrote:
Unless, of course, you have quotes in your data.
With perl you can use the quote() function to ensure the whole line
gets in.
Or placeholders.
- Cs.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
essage-
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 data
blem 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: Textfil
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
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 ques
