Shell Programming and Scripting

A delete statement would be easier, as the syntax is much the same as the select statement:

Code:

sed "s/^DELETE/SELECT COUNT(1)/" file.sql

Where does your DML come from? Wouldn't it be better to have whatever generates that, generate a separate script to do the select count(1) stuff too - instead of this hacky stuff?

First of all thanks a lot......!!!
you came like a savior.....

there is a separate script which checks the count.....I implemented simple extraction of WHERE clause and creation of SELECT COUNT(*) statements but it is not working for complex statements.....

let me try the logic you suggested to create SELECT COUNT(*) statements for DELETE statements

---------- Post updated at 07:39 PM ---------- Previous update was at 07:04 PM ----------

it is working for DELETE too....
thanks