in reply to perl and mysql parse a text file
Read the entire contents into a single scalar (my $contents = do { local $/; <FILE> };) and pass that to the database using an insert statement you've prepared. See the Handling BLOB / LONG / Memo Fields in the DBI documentation.
|
|---|