Hello, I am running MySQL on a linux server I am trying to figure out a proper Shell Script to do the following

I have a folder containing 300 txt files that contain html snippets

I have a Table with 3 columns, 2 without the primary key

Columns
tags
description

I would like to import all of these txt files into separate rows into the description column but provide a static value for the tags column.

CSV is not an option do to the html code.

Anyone have any ideas?