OMG I'm sure that's why I'm having problems. Do you know the syntax
for granting the file_priv? The following doesn't seem to work:
mysql> GRANT file ON bs.table1 TO [EMAIL PROTECTED] IDENTIFIED BY
'password123';
On Jan 16, 2004, at 3:15 PM, Jason Wong wrote:
On Saturday 17 January 2004 03:4
On Saturday 17 January 2004 03:44, Jough P wrote:
> On Jan 16, 2004, at 9:12 AM, Jough P wrote:
> > Greetings all, I can't get LOAD_FILE to work in an INSERT statement
> > from PHP. The generated sql works when you're in mysql but won't work
> > from PHP.
Are you using the same user in both cases
Greetings all, I'm still having problems with LOAD_FILE. If anyone is
using it and could post some examples that would be fabulous.
Thanks tons!!!
On Jan 16, 2004, at 9:12 AM, Jough P wrote:
Greetings all, I can't get LOAD_FILE to work in an INSERT statement
from PHP. The generated sql works
I've tried a couple different paths and double checked them.
Permissions are 755. Like I said that exact same SQL statement inserts
the correct record from the mysql command line.
mysql> INSERT INTO photo VALUES('',
LOAD_FILE("/Library/WebServer/Documents/var/tmp/default_smiley.png"));
does
Jough P wrote:
Greetings all, I can't get LOAD_FILE to work in an INSERT statement from
PHP. The generated sql works when you're in mysql but won't work from PHP.
BSDB is my database object.
sql_query basically just does a mysql_query and some error outputting
stuff. There error is:
Column 'p
Greetings all, I can't get LOAD_FILE to work in an INSERT statement
from PHP. The generated sql works when you're in mysql but won't work
from PHP.
BSDB is my database object.
sql_query basically just does a mysql_query and some error outputting
stuff. There error is:
Column 'photo' cannot be
6 matches
Mail list logo
