Shell Programming and Scripting

grep $col tableextract2.sql | while read line ; do 
   echo $line
   #massage $line here
done

#line333=`cat tablextract2.sql | grep $colname1`
    
                                                        grep $colname1 tablextract1.sql | while read line22 ; do
                                                        echo "from while loop: $line22"
                                                        echo "counter: $counter"
                                                        counter=`expr $counter + 1`

                                                        if [[ "$line22" != "" ]]
                                                        then
                                                                len2=${#line22}
#                                                                charlast=${line22:$len2-1:$len2}
#                                                               if [ "$charlast" = "," ]
#                                                                then
#                                                                     line22=${line22:0:$len2-1}
#                                                               fi
                                                        else
                                                                 insert_column "$table_name" "$line11"
                                                        fi

grep $col tableextract2.sql > tmpfile
if [[ -s tmpfile ]] ; then 
  while read line ; do
      echo $line
     #massage $line here
  done < tmpfile
elif
  echo nothing grepped
fi

cat > tablextract2.sql
CREATE TABLE `Table11` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`entityName` enum('Lines','EndUsers') COLLATE utf8_unicode_ci NOT NULL,
`parentAllianceMigrationProjectId` int(11) NOT NULL,
`lastModified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2000 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

colname1="id"
flag=0
 grep -w -i $colname1 tablextract2.sql | while read line ; do
        echo "$line"
        flag=1
        echo "flag: $flag"
done
echo "flag: $flag"

`id` int(11) NOT NULL AUTO_INCREMENT,
flag: 1
PRIMARY KEY (`id`)
flag: 1
flag: 0