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
Insert HTML data into table in MySql
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.×