Insert HTML data into table in MySql

Posted July 19, 2017 3.8k views
MySQLUbuntu 16.04


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?

1 comment

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.

Submit an Answer
1 answer

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!