sqls

09/16/2011 17:56 shadowkiller990#1
How to remove lines from cq_action using sql

like remove lines from <Greater then and >lower then how do i add that in?
09/16/2011 21:26 Thorlon#2
I dont know but, you could google sql remove code or something. Just a guess lol'

Thanks :)
09/17/2011 01:59 drukkie#3
Quote:
Originally Posted by shadowkiller990 View Post
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

[Only registered and activated users can see links. Click Here To Register...]

there it is :D not hard to find google and done :D
09/19/2011 15:11 magewarior2#4
use rows like

Code:
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
---------------------------------------------------------------