Storing images in MySQL [closed]

by

If the image is located on your MySQL host, you could use the LOAD_FILE() function to store the image in a BLOB field:

CREATE TABLE MyTable (id INT, image BLOB);

INSERT INTO MyTable (id, image) VALUES(1, LOAD_FILE('/tmp/your_image.png'));

You have to make sure that the image file is readable by MySQL, and that the MySQL user has the FILE privilege. To grant the FILE privilege, log-in as root and execute:

GRANT FILE ON *.* TO 'mysql_user'@'localhost';

More Related Contents:

  1. When I want to install MySQL I faced this issue “root account password” I forgot it
  2. MySQL: Enable LOAD DATA LOCAL INFILE
  3. Restoring MySQL database from physical files
  4. MySQL Trigger after update only if row has changed
  5. MySQL “WITH” clause
  6. MySQL Query – Records between Today and Last 30 Days
  7. MySQL root access from all hosts
  8. Basics of Foreign Keys in MySQL?
  9. How to import data from text file to mysql database
  10. Select last N rows from MySQL
  11. Why there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT clause?
  12. What is the benefit of zerofill in MySQL?
  13. MySQL user DB does not have password columns – Installing MySQL on OSX
  14. How to select date from datetime column?
  15. #1139 – Got error ‘repetition-operator operand invalid’ from regexp
  16. How do I use properly CASE..WHEN in MySQL
  17. MySQL – can I limit the maximum time allowed for a query to run?
  18. MySQL ‘user_id’ in where clause is ambiguous problem
  19. What does it mean when MySQL is in the state “Sending data”?
  20. How to insert data to MySQL with auto-incremented column(field)?
  21. SQL Server equivalent of substring_index function in MySQL
  22. Remote connect to clearDB heroku database
  23. How to add a where clause in a MySQL Insert statement?
  24. Use MySQL to determine whether today is a user’s birthday
  25. How can you determine how much disk space a particular MySQL table is taking up?
  26. MySQL 5.6 – DENSE_RANK like functionality without Order By
  27. How can I “select *” from a table in MySQL but omit certain columns?
  28. For homebrew mysql installs, where’s my.cnf?
  29. Force MySQL to return duplicates from WHERE IN clause without using JOIN/UNION?
  30. comparison of truncate vs delete in mysql/sqlserver [duplicate]

Leave a Comment