Questions tagged [mysql-loadfile]
33 questions
-1
votes
3 answers
LOAD_FILE returns only null
I want to insert the image to the database with this query:
SELECT LOAD_FILE('/Users/juliagaskevich/cool-background.svg');
I checked that:
File size < max_allowed_packet.
File has read, write and execute permissions to everyone.
The user, what I'm…

SCorpi
- 1
- 1
- 3
-1
votes
2 answers
Problem adding an image to database using SQL
INSERT INTO items (id,name,image,price) VALUES('1','iphone 5s',LOAD_FILE('C:\xampp\htdocs\project\1.jpg'),300);
this statement cause error
INSERT INTO items (id,name,image,price) VALUES('1','iphone…

Anupama Dikkumbura
- 27
- 5
-2
votes
1 answer
Python 3.9 Initializing constants of class with static methods yields error
I'm trying to create a class in python3.9 to dynamily load constant values of the class by loading a file from a static method as follows:
class SQLQueries(object):
CLIPAPP = SQLQueries.load_query_statement('clinapp.sql')
MENSALIDADES =…

Pj-
- 430
- 4
- 14