Project Home

csv-sql-bulk

Abstract

Load a CSV file, find a cell with a SQL statement in it, like this:

System Message: WARNING/2 (/tmp/conf-pub-tmp.txt, line 10)

Literal block expected; none found.

Table of Contents

Description

Load a CSV file, find a cell with a SQL statement in it, like this:

sql: insert into person (id, name) values (ID, NAME);

Then iterate through the csv file again, assuming we have columns with a header of ID and NAME, replacing the values in the SQL statement for every row. Print the replacements on stdout.

Please Donate!

Important

This computer program or library is provided for free. I am aware that some of the programs that I provide for free allow people to get their work done faster or better, save them time and money. If you are using this program for benefit, especially if you are using it within a commercial environment and it saves you time or work, please consider making a donation by sending me a book from my Amazon Wishlist or by a direct donation to my company's PayPal account by clicking on the link below.

Download

Download program here.