Hi,
> my question is: is it possible to load in a Longtext column
> a .txt file? furthermore, is it possible to do that with a .xml file?
of course..
at first you must use seperator, field-encloser and line-terminator, which
is not contained in your data. for example this way:
SELECT *
FROM YOURTABLE
INTO [LOCAL] OUTFILE 'c:/out.txt'
FIELDS TERMINATED BY '}}'
FIELDS ENCLOSED BY '{{'
LINES TERMINATED BY ']]'
Then you can easily import this file with MySQL-Front
(http://www.mysqlfront.de) . Use the "Import/Export" => "Import Textfile".
There you must specify your seperator, field-encloser and lines-terminator.
Greetings,
Ansgar
---------------------------------------------------------------------
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