How to insert image into mysql db table?

Asked Jan 29 '17 at 14:48

Active Jan 29 '17 at 15:01

Viewed 54 times

output mysql> insert into test (id,img) values(1,LOAD_FILE('/home/ubundu/pic.jpg')); Query OK, 1 row affected (0.55 sec)

mysql> select * from test;
+------+------+
| id   | img  |
+------+------+
|    1 | NULL |
+------+------+
1 row in set (0.02 sec)

edited Jan 29 '17 at 15:01

asked Jan 29 '17 at 14:48

Sharmila Shankar

Possible duplicate: http://stackoverflow.com/questions/18069054/mysql-load-file-loads-null-values – Tim Biegeleisen Jan 29 '17 at 14:51
3

Possible duplicate of [MySQL LOAD\_FILE() loads null values](http://stackoverflow.com/questions/18069054/mysql-load-file-loads-null-values) – Gurwinder Singh Jan 29 '17 at 14:51
Please go through these links, and if nothing works, come back to this question and update with what you have tried. – Tim Biegeleisen Jan 29 '17 at 14:52

0 Answers0