I have an HTML file which i would want to insert into a table as a single row.
I am currently using LOAD DATA LOCAL INFILE ‘/var/lib/tomcat7/webapps/app/index.html’ INTO TABLE html_sample
but it is storing each as individual row in the table.
Is there anyway to store the entire html file as a single row?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.