Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
install mysql 3.24 on ubuntu 16.04 Question Question
Automatically restart MySQL on Ubuntu 16.04.x - If statement may be wrong? Question Question

Question

Insert HTML data into table in MySql

Posted July 19, 2017 3.8k views
MySQLUbuntu 16.04

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?

Add a comment
Amrutha
By:
Amrutha

Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
install mysql 3.24 on ubuntu 16.04 Question Question
Automatically restart MySQL on Ubuntu 16.04.x - If statement may be wrong? Question Question
Add a comment
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
Boyan21Iliev March 13, 2021

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!

Reply Report

Related

Looking for something else?

Ask a new question Search for more help