From: <sinisa
Date: August 2 1999 9:07pm
Subject: inserting file into specific row with where clause
List-Archive: http://lists.mysql.com/mysql/9138
Message-Id: <14246.2176.963835.322720@localhost.localdomain>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

System Administrator writes:
 > 
 > 
 > I am trying to insert a file from the server into a single field of a
 > multicolumn ROW.  I have tried
 > using load data infile into a temporary table, and then, using an update
 > and select together to get that file into the original table where I
 > want it, but it seems that update doesnt work together with select... If
 > I use an insert, then I cannot specify the row.
 > 
 > Is there any way to get a file from the server into a single specify
 > cell of a table, where I specify exactly which row I want it to go in by
 > way of a where clause?
 > 
 > Thank you very much.
 > 
 > 
 > 

Hi!


yes, there is in 3.23.  There is a new command LOAD_FILE(file_name).

Sinisa

+----------------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___     ==  mysql@stripped            |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Sinisa Milivojevic          |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|     mailto:sinisa@stripped|
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Larnaka, Cyprus             |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                             |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                            |
|             /*/             \*\                Developers Team       |
+----------------------------------------------------------------------+