#!/bin/bash export JOB_ID=1 for line in `cat list.txt` do echo "INSERT INTO t_task(job,key_message) VALUES($JOB_ID,'${line}');" done