#!/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
