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 |
+----------------------------------------------------------------------+
