5 messages in com.mysql.lists.mysqlRe: load_file on NT
FromSent OnAttachments
Jeremy Cole14 Dec 1999 08:46 
Steve Ruby14 Dec 1999 08:54 
sin...@mysql.com14 Dec 1999 08:57 
Jeremy Cole14 Dec 1999 08:57 
Matthew Vanecek14 Dec 1999 17:27 
Subject:Re: load_file on NT
From:sin...@mysql.com (sin@mysql.com)
Date:12/14/1999 08:57:04 AM
List:com.mysql.lists.mysql

Jeremy Cole writes:

can load_file() be used on NT?

I keep getting:

mysql> select * from t1; +---+------+ | n | f | +---+------+ | 1 | | +---+------+ 1 row in set (0.01 sec)

mysql> update t1 set f=load_file('c:\\autoexec.bat') where n = 1; ERROR 1064: You have an error in your SQL syntax near '('c:\\autoexec.bat') where n = 1' at line 1

am I using it wrong... or is it not supported??

If it's not supported, how would I get an image into the MySQL server without it?

Thanks,

Jeremy

Hi!

If you are using 3.23.xx it should work.

Sinisa

+----------------------------------------------------------------------+ | TcX ____ __ _____ _____ ___ == mys@tcx.se | | /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic | | /*/ /*/ /*/ \*\_ |*| |*||*| mailto:sin@cytanet.com.cy| | /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus | | /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ | | ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ | | /*/ \*\ Developers Team | +----------------------------------------------------------------------+