Problem adding an image to database using SQL [duplicate]












-1















This question already has an answer here:




  • How to use LOAD_FILE to load a file into a MySQL blob?

    5 answers




INSERT INTO items (id,name,image,price) VALUES('1','iphone 5s',LOAD_FILE('C:xampphtdocsproject1.jpg'),300);


this statement cause error



INSERT INTO items (id,name,image,price) VALUES('1','iphone 5s',LOAD_FILE('C:xampphtdocsproject1.jpg'),300)

MySQL said: Documentation


here is the error



#1048 - Column 'image' cannot be null





mariadb mysql-loadfile







share|improve this question















marked as duplicate by Madhur Bhaiya, jww, Makyen, sideshowbarker, Pearly Spencer Nov 15 '18 at 1:25


This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.















  • Pick a single database engine - the code required will be specific to that engine. SQL Server has no load_file function.
    – SMor
    Nov 14 '18 at 3:22










  • i used maria db.
    – Anupama Dikkumbura
    Nov 14 '18 at 3:34






  • 3




    Possible duplicate of MySQL LOAD_FILE is not working as expected, How do I use LOAD_FILE to insert value from a file into a table?, LOAD_FILE returns NULL, etc.
    – jww
    Nov 14 '18 at 16:48


















-1















This question already has an answer here:




  • How to use LOAD_FILE to load a file into a MySQL blob?

    5 answers




INSERT INTO items (id,name,image,price) VALUES('1','iphone 5s',LOAD_FILE('C:xampphtdocsproject1.jpg'),300);


this statement cause error



INSERT INTO items (id,name,image,price) VALUES('1','iphone 5s',LOAD_FILE('C:xampphtdocsproject1.jpg'),300)

MySQL said: Documentation


here is the error



#1048 - Column 'image' cannot be null





mariadb mysql-loadfile







share|improve this question















marked as duplicate by Madhur Bhaiya, jww, Makyen, sideshowbarker, Pearly Spencer Nov 15 '18 at 1:25


This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.















  • Pick a single database engine - the code required will be specific to that engine. SQL Server has no load_file function.
    – SMor
    Nov 14 '18 at 3:22










  • i used maria db.
    – Anupama Dikkumbura
    Nov 14 '18 at 3:34






  • 3




    Possible duplicate of MySQL LOAD_FILE is not working as expected, How do I use LOAD_FILE to insert value from a file into a table?, LOAD_FILE returns NULL, etc.
    – jww
    Nov 14 '18 at 16:48
















-1












-1








-1








This question already has an answer here:




  • How to use LOAD_FILE to load a file into a MySQL blob?

    5 answers




INSERT INTO items (id,name,image,price) VALUES('1','iphone 5s',LOAD_FILE('C:xampphtdocsproject1.jpg'),300);


this statement cause error



INSERT INTO items (id,name,image,price) VALUES('1','iphone 5s',LOAD_FILE('C:xampphtdocsproject1.jpg'),300)

MySQL said: Documentation


here is the error



#1048 - Column 'image' cannot be null





mariadb mysql-loadfile







share|improve this question
















This question already has an answer here:




  • How to use LOAD_FILE to load a file into a MySQL blob?

    5 answers




INSERT INTO items (id,name,image,price) VALUES('1','iphone 5s',LOAD_FILE('C:xampphtdocsproject1.jpg'),300);


this statement cause error



INSERT INTO items (id,name,image,price) VALUES('1','iphone 5s',LOAD_FILE('C:xampphtdocsproject1.jpg'),300)

MySQL said: Documentation


here is the error



#1048 - Column 'image' cannot be null




This question already has an answer here:




  • How to use LOAD_FILE to load a file into a MySQL blob?

    5 answers







mariadb mysql-loadfile




mariadb mysql-loadfile






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 14 '18 at 16:51









jww

52.7k39221483




52.7k39221483










asked Nov 14 '18 at 3:19









Anupama Dikkumbura

74




74




marked as duplicate by Madhur Bhaiya, jww, Makyen, sideshowbarker, Pearly Spencer Nov 15 '18 at 1:25


This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.






marked as duplicate by Madhur Bhaiya, jww, Makyen, sideshowbarker, Pearly Spencer Nov 15 '18 at 1:25


This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.














  • Pick a single database engine - the code required will be specific to that engine. SQL Server has no load_file function.
    – SMor
    Nov 14 '18 at 3:22










  • i used maria db.
    – Anupama Dikkumbura
    Nov 14 '18 at 3:34






  • 3




    Possible duplicate of MySQL LOAD_FILE is not working as expected, How do I use LOAD_FILE to insert value from a file into a table?, LOAD_FILE returns NULL, etc.
    – jww
    Nov 14 '18 at 16:48




















  • Pick a single database engine - the code required will be specific to that engine. SQL Server has no load_file function.
    – SMor
    Nov 14 '18 at 3:22










  • i used maria db.
    – Anupama Dikkumbura
    Nov 14 '18 at 3:34






  • 3




    Possible duplicate of MySQL LOAD_FILE is not working as expected, How do I use LOAD_FILE to insert value from a file into a table?, LOAD_FILE returns NULL, etc.
    – jww
    Nov 14 '18 at 16:48


















Pick a single database engine - the code required will be specific to that engine. SQL Server has no load_file function.
– SMor
Nov 14 '18 at 3:22




Pick a single database engine - the code required will be specific to that engine. SQL Server has no load_file function.
– SMor
Nov 14 '18 at 3:22












i used maria db.
– Anupama Dikkumbura
Nov 14 '18 at 3:34




i used maria db.
– Anupama Dikkumbura
Nov 14 '18 at 3:34




3




3




Possible duplicate of MySQL LOAD_FILE is not working as expected, How do I use LOAD_FILE to insert value from a file into a table?, LOAD_FILE returns NULL, etc.
– jww
Nov 14 '18 at 16:48






Possible duplicate of MySQL LOAD_FILE is not working as expected, How do I use LOAD_FILE to insert value from a file into a table?, LOAD_FILE returns NULL, etc.
– jww
Nov 14 '18 at 16:48














2 Answers
2






active

oldest

votes


















0














Please double check the file path of your "1.jpg" or maybe look at the image format whether it is .jpg or .png.



Else, try this format:




LOAD_FILE('../1.jpg')




"Different backslash position"



I do not think you should mention the C:/xampp/htdocs/project because you are already in the project folder when you run your code.



Hopefully it is working.






share|improve this answer





























    0














    You must escape backslashes in any string:



    ... LOAD_FILE('C:\xampp\htdocs\project\1.jpg') ...


    Or, since MySQL will 'correctly' interpret forward-slashes, even on Windows:



    ... LOAD_FILE('C:/xampp/htdocs/project/1.jpg') ...


    (I assume image is declared BLOB or MEDIUMBLOB?)






    share|improve this answer




























      2 Answers
      2






      active

      oldest

      votes








      2 Answers
      2






      active

      oldest

      votes









      active

      oldest

      votes






      active

      oldest

      votes









      0














      Please double check the file path of your "1.jpg" or maybe look at the image format whether it is .jpg or .png.



      Else, try this format:




      LOAD_FILE('../1.jpg')




      "Different backslash position"



      I do not think you should mention the C:/xampp/htdocs/project because you are already in the project folder when you run your code.



      Hopefully it is working.






      share|improve this answer


























        0














        Please double check the file path of your "1.jpg" or maybe look at the image format whether it is .jpg or .png.



        Else, try this format:




        LOAD_FILE('../1.jpg')




        "Different backslash position"



        I do not think you should mention the C:/xampp/htdocs/project because you are already in the project folder when you run your code.



        Hopefully it is working.






        share|improve this answer
























          0












          0








          0






          Please double check the file path of your "1.jpg" or maybe look at the image format whether it is .jpg or .png.



          Else, try this format:




          LOAD_FILE('../1.jpg')




          "Different backslash position"



          I do not think you should mention the C:/xampp/htdocs/project because you are already in the project folder when you run your code.



          Hopefully it is working.






          share|improve this answer












          Please double check the file path of your "1.jpg" or maybe look at the image format whether it is .jpg or .png.



          Else, try this format:




          LOAD_FILE('../1.jpg')




          "Different backslash position"



          I do not think you should mention the C:/xampp/htdocs/project because you are already in the project folder when you run your code.



          Hopefully it is working.







          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered Nov 14 '18 at 3:38









          Json

          135




          135

























              0














              You must escape backslashes in any string:



              ... LOAD_FILE('C:\xampp\htdocs\project\1.jpg') ...


              Or, since MySQL will 'correctly' interpret forward-slashes, even on Windows:



              ... LOAD_FILE('C:/xampp/htdocs/project/1.jpg') ...


              (I assume image is declared BLOB or MEDIUMBLOB?)






              share|improve this answer


























                0














                You must escape backslashes in any string:



                ... LOAD_FILE('C:\xampp\htdocs\project\1.jpg') ...


                Or, since MySQL will 'correctly' interpret forward-slashes, even on Windows:



                ... LOAD_FILE('C:/xampp/htdocs/project/1.jpg') ...


                (I assume image is declared BLOB or MEDIUMBLOB?)






                share|improve this answer
























                  0












                  0








                  0






                  You must escape backslashes in any string:



                  ... LOAD_FILE('C:\xampp\htdocs\project\1.jpg') ...


                  Or, since MySQL will 'correctly' interpret forward-slashes, even on Windows:



                  ... LOAD_FILE('C:/xampp/htdocs/project/1.jpg') ...


                  (I assume image is declared BLOB or MEDIUMBLOB?)






                  share|improve this answer












                  You must escape backslashes in any string:



                  ... LOAD_FILE('C:\xampp\htdocs\project\1.jpg') ...


                  Or, since MySQL will 'correctly' interpret forward-slashes, even on Windows:



                  ... LOAD_FILE('C:/xampp/htdocs/project/1.jpg') ...


                  (I assume image is declared BLOB or MEDIUMBLOB?)







                  share|improve this answer












                  share|improve this answer



                  share|improve this answer










                  answered Nov 14 '18 at 16:03









                  Rick James

                  66.1k55897




                  66.1k55897















                      -

                      Popular posts from this blog

                      How to pass form data using jquery Ajax to insert data in database?

                      Image
                      .everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box; } 1 I have 4 tables namely stud, country_master_academic,master_state and master_city. The main problem is that my form consists of many different fields like textbox, radio buttons, dropdown and an image file, so i am getting really confused. I can't insert data in database. Please help me. I tried many times but its not working. Thanks for the help in advance. Modal in home.php page <div class="container"> <div class="modal fade" id="add_data_modal" role="dialog"> <div class="modal-dialog"> <div class="modal-content"> ...
                      Read more

                      National Museum of Racing and Hall of Fame

                      Image
                      Coordinates: 43°04′35″N 73°46′24″W  /  43.0763°N 73.7734°W  / 43.0763; -73.7734 Professional sports hall of fame in Saratoga Springs, New York National Museum of Racing and Hall of Fame National Museum of Racing and Hall of Fame Established 1951 Location Saratoga Springs, New York Type Professional sports hall of fame Director Cathy Marino Curator Victoria Tokarowski Website racingmuseum.org The National Museum of Racing and Hall of Fame was founded in 1951 in Saratoga Springs, New York, to honor the achievements of American Thoroughbred race horses, jockeys, and trainers. In 1955, the museum moved to its current location on Union Avenue near Saratoga race course, at which time inductions into the hall of fame began. Each spring, following the tabulation of the final votes, the announcement of new inductees is made, usually during Kentucky Derby Week in early May. The actual inductions are held in mid-August during the Saratoga race meeting...
                      Read more

                      Guess what letter conforming each word

                      Image
                      6 $begingroup$ This is an entry in the Fortnightly Topic Challenge #41: Short and Sweet. 1 letter only could be mean anything . With an additional letter in front , could be used as medicine component and something you definitely learn or at least heard once. Add another letter in front , you would possibly hear that many times . Add an additional letter in front , you would found an independent country . With an additional letter, in the end , you would found something related to apple . Add another letter in the end , you would found something bad . Hint: Each letter is unique . word knowledge letters chemistry share | improve this question ...
                      Read more