#!/bin/bash cat ./input/sample.txt | while read line do num=$(echo $line | cut -d"," -f1) fruit=$(echo $line | cut -d"," -f2) color=$(echo $line | cut -d"," -f3) echo "insert into myfruits (code,name,color) values ($num,\"$fruit\",\"$color\")" >> ./sql.txt done