sqls

[shadowkiller990]

How to remove lines from cq_action using sql

like remove lines from <Greater then and >lower then how do i add that in?

[Thorlon]

I dont know but, you could google sql remove code or something. Just a guess lol'

Thanks

[drukkie]

Originally Posted by shadowkiller990

How to remove lines from cq_action using sql

like remove lines from <Greater then and >lower then how do i add that in?

i dont know if its ok to give links but well



there it is not hard to find google and done

[magewarior2]

use rows like

delete from [COLOR="Red"]cq_action[/COLOR] where [COLOR="lime"]id[/COLOR] >= [COLOR="Blue"]6400040[/COLOR] and [COLOR="lime"]id[/COLOR] <= [COLOR="blue"]6400043[/COLOR];

deletes those rows:
6400040
6400041
6400042
6400043
---------------------------------------------------------------
delete from [COLOR="red"]cq_action[/COLOR] where [COLOR="lime"]id[/COLOR]= [COLOR="Blue"]6400040[/COLOR];

deletes this row:
6400040
---------------------------------------------------------------