Insert HTML data into table in MySql

July 19, 2017 1.8k views
MySQL Ubuntu 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
Be the first one to answer this question.