At 02:48 PM 7/20/2006, you wrote:
Hello everyone,
Without scripting, can this be done from mysql> command line? The
'publications' field is mediumtext in table 'research'. Since
'publication' is pretty long, I want to save it in a file on the file
system. But I don't know how, or if that's even possible, to grab the
content from the file and use it in the following update statement?
mysql>update research set publications='loooong text in a file' where
uid=319;
Any ideas?
Thanks in advance,
Bing
Bing,
You could create a temporary table with a single text field and
then use "Load Data Infile <filepath> ..." to put the text data into the
temporary table. Once it is there you can use the temporary table to update
your research table.
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
