Actually, the structure
while read someVariable
do
stuff
done < fileNameis just a way to step through a file. With each iteration of the "while" loop, the next line in fileName is stored in...
This'll work for you, unless you really wanted to use vi commands for some reason...while read LINE
do
echo $LINE >> resultFile
echo $LINE | grep -q "CREATE TABLE"
if [ $? -eq 0 ]; then
...