I took a look at the command but I don't see where you tell
mysql which specific field to use within a specific column. The
rest of the column is fine and I understand the id=# points at the
column that I want.
Thanks for the response btw,
Mike Wendell
At 01:07 PM 11/21/2002 +0200, you wrote:
theapparatus,
Thursday, November 21, 2002, 5:35:04 AM, you wrote:
tandn> I just have a quick question. I've been setting up a
tandn> website using a MySQL database loaded with a large
tandn> number of articles but I'm having a problem.
tandn> Some of the articles did not load correctly into the
tandn> database. Is there a method of loading a text (well,
tandn> in this case a *.html file) file directly into a field within
tandn> a column?
Seems, your articles are not proper escaped. In your case you can use
LOAD_FILE() function:
http://www.mysql.com/doc/en/String_functions.html
or you can use QUOTE() function (it's implemented since 4.0.3)
or you can use PHP, Perl etc functions to do it.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------
Introducing NetZero Long Distance
1st month Free!
Sign up today at: www.netzerolongdistance.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
