Hi,
Now I am puzzled by the filepath,Load_file, I install
MySQL in Windows98, the file which i want to insert to
table is c:\P1.bmp
when I run load_file in mysql command line,it succeeds
mysql> insert into blobtable (load_file("/P1.bmp"))
but i don't know why i should use slash instead of
backslash on windows.
if i use the absolute path load_file("c:\P1.bmp"), the
blob field in table is NULL
I also run insert into blobtable
(load_file("/P1.bmp"))in mysqlgui,it also insert null
to table.
i run this query in my Visual basic, same problem.
_________________________________________________________
Do You Yahoo!?
到世界杯主题公园玩一玩，赢取世界杯门票乐一乐。
http://cn.worldcup.yahoo.com/
---------------------------------------------------------------------
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
