RE: Load_File issue

2002-02-11 Thread Todd Williamsen
First off, you trying to insert the image into the database or just its path? -Original Message- From: yue cheng [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 06, 2002 2:23 PM To: [EMAIL PROTECTED] Subject: Load_File issue Hi, Now I am puzzled by the filepath,Load_file, I

Re: Load_File issue

2002-02-11 Thread Paul DuBois
At 4:22 +0800 2/7/02, yue cheng wrote: >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

Re: Load_File issue

2002-02-06 Thread Paul DuBois
At 4:22 +0800 2/7/02, yue cheng wrote: >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

RE: Load_File issue

2002-02-06 Thread Todd Williamsen
First off, you trying to insert the image into the database or just its path? -Original Message- From: yue cheng [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 06, 2002 2:23 PM To: [EMAIL PROTECTED] Subject: Load_File issue Hi, Now I am puzzled by the filepath,Load_file, I

Load_File issue

2002-02-06 Thread yue cheng
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 backsl