Hi Guys,
I have a file. Each record needs to inserted into a table. The table also have other columns which needs to be inserted with Shell variables.
The following is the file.
Error code None.
Error Code 1
The shell script is having these variables.
Name=Magesh
Dep=Coding
The output i need should be like this.
Insert into table(col1,col2,col3) values ('Magesh','Coding','Error code None');
Insert into table(col1,col2,col3) values ('Magesh','Coding','Error Code 1');
Basically for all the lines $Name and $Dep needs to be picked up. I am not sure how to pass it to the insert queries.
Cheers!!!!!