Shell Programming and Scripting

$ sed 's/DEFAULT CHARSET=[^ \;]*//;s/COLLATE=[^ \;]*//;s/AUTO_INCREMENT=[^ \;]*/AUTO_INCREMENT=0 /' test.txt
) ENGINE=InnoDB  AUTO_INCREMENT=0   COMMENT="testing deletion using sed";
) ENGINE=InnoDB AUTO_INCREMENT=0    COMMENT="testing deletion using sed";
) ENGINE=MyISAM ;


$ awk '
{
    for (word=1;word <=NF; word++)
    {
        if  (index($word,"DEFAULT") || index($word, "CHARSET=") || index($word, "COLLATE="))
            $word=""
        else
        if  (index($word, "AUTO_INCREMENT="))
            $word="AUTO_INCREMENT=0"
    }
    print $0 

}
' test.txt
) ENGINE=InnoDB   AUTO_INCREMENT=0  COMMENT="testing deletion using sed";
) ENGINE=InnoDB AUTO_INCREMENT=0    COMMENT="testing deletion using sed";
) ENGINE=MyISAM