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…
-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 =…
1 2
3