AnsweredAssumed Answered

batch delete in sql commander

Question asked by RaymondChan on Feb 5, 2015
Latest reply on Mar 11, 2015 by gregor

hello

is there any way to run several delete sql at the same time like:

 

delete  from picomp2

where picomp2.time >= '2013-01-01 00:00:00' and  picomp2.time < '2013-12-31 00:00:00'

and picomp2.tag = 'a'

delete  from picomp2

where picomp2.time >= '2013-01-01 00:00:00' and  picomp2.time < '2013-12-31 00:00:00'

and picomp2.tag = 'b'

delete  from picomp2

where picomp2.time >= '2013-01-01 00:00:00' and  picomp2.time < '2013-12-31 00:00:00'

and picomp2.tag = 'c'

 

Now it shows the error:

[SQL Parser] [Line 4] Syntax error near 'delete'.

 

Please advise.

Thanks

 

 

Outcomes