Shell Programming and Scripting

You keep changing your post while I'm trying to respond to it...

If the code:

Code:

#!/bin/bash
awk -F "," -vmytable="${1}" '{
a = "CREATE TABLE " mytable "(x int, y string)";
}' file1.txt file2.txt

is working for you, a much simpler and much faster script will produce the same output:

Code:

Yes. That is an empty file. It will produce the same output as your awk script (as long as file1.txt and file2.txt are readable text files.

Hi,

In my bash script using awk i'm achieving many things and my requirement was different where i wanted to pass the tables names through the command promt. And once i create the table ,i'm using that for different purpose and above post i have not shown rest of the code.

Whatever you suggested is really good and time saving but i'm not using that because my other requirements are different.

Thanks,
Shree