Assigning a value from a text file to variable in shell in loop

Another approach rater than looping with bash:

<input.csv cut -d',' --output-delimiter=' ' -f1,2,3 |
  xargs -l printf 'delete from table1.test where id="%s" and code="%s" and country="%s";n' >deletes.sql

Explanations:

• <input.csv cut -d',' --output-delimiter=' ' -f1,2,3 |: extract first 3 comma delimited fields from input.csv, and turn them into space delimited arguments.
• xargs -l printf >deletes.sql: xargs feeds lines of arguments to printf to be formatted into SQL statements and writes the output to the deletes.sql file.

Or use awk to do it all at once:

awk -F, '{ printf("delete from table1.test where id="%s" and code="%s" and country="%s";n", $1, $2, $3) }' input.csv >deletes.sql

Or with a stand-alone csv2sql awk script:

#!/usr/bin/env -S awk -f

BEGIN {
  FS=","
}

{
  printf( "delete from table1.test where id="%s" and code="%s" and country="%s";n", $1, $2, $3)
}

Usage:

# Make csv2sql executable
chmod +x csv2sql

# Run it
./csv2sql input.csv >output.sql

Output generated from sample:

delete from table1.test where id="1234" and code="12" and country="IN";
delete from table1.test where id="1111" and code="10" and country="SA";
delete from table1.test where id="2222" and code="11" and country="EU";
delete from table1.test where id="3333" and code="13" and country="CN";
delete from table1.test where id="4444" and code="14" and country="US";

Use a while read loop, setting $IFS to a comma to split the lines.

while IFS=, read -r var1 var2 var3 rest
do
    echo "delete from table1.test where id=$var1 and code=$var2 and country='$var3'"
done < test.txt | mysql ...