BASH - using a for loop to loop over an array and create a file from the loop body

Question

It;s only outputting the final loop body because of the way my loop is set up, the variable var's final result will be the final element in my array. How would I loop through the body and add all of the results of my array to the .sql file?

please include your code as text, not an image.

ddavison
– ddavison

2015-12-14 13:59:55 +00:00
Commented Dec 14, 2015 at 13:59 — ddavison
– ddavison, Commented Dec 14, 2015 at 13:59

John Zwinck · Accepted Answer · 2015-12-14 14:35:21Z

1

Try this:

echo "CREATE TABLE $NameOfTable (" > "$NameOfSqlFile.sql"
for i in "${ColumnArray[@]}"
do
echo "$i,"
done >> "$NameOfSqlFile.sql"
echo ")" >> "$NameOfSqlFile.sql"

edited Dec 14, 2015 at 14:35

answered Dec 14, 2015 at 14:09

John Zwinck

252k44 gold badges347 silver badges459 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user3544582 Over a year ago

That would create an sql text file for each element in my array. I want one text file to hold the loop results of my array

John Zwinck Over a year ago

@user3544582: I've updated my answer--please check again.

user3544582 Over a year ago

Beautiful! If you remove the EOF at the end of where your wrote echo, it works!

Collectives™ on Stack Overflow

BASH - using a for loop to loop over an array and create a file from the loop body

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related