Hi,
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.
Hello there,
I recently had to do the same thing. What I did was to incode the HTML into base64. I think it’s the safest scenario. There might be other solutions but I think this might be the cleanest approach:
String originalInput = "test input";
String encodedString = Base64.getEncoder().encodeToString(originalInput.getBytes());
/* insert to database */
I hope that this helps you the same way it helped me!
Hi @Amrutha I’m not sure how many Tomcat users there are in this forum, so I would suggest you ask in a Tomcat forums instead - have a look in https://stackoverflow.com/questions/tagged/tomcat