SEO

#1 (**permalink**) 02-28-2008, 10:30 AM

hello
how can i use variables in sql.
for eg

/* CLEAN UP PARTICULAR TRADE */
begin
declare tradeid int;
set tradeid=100;

select * from executions where trade_id=tradeid

end

#2 (**permalink**) 02-28-2008, 10:30 AM

On Sat, 15 Dec 2007 09:05:17 -0800 (PST), Junkone wrote:
> hello
> how can i use variables in sql.
> for eg
>
> /* CLEAN UP PARTICULAR TRADE */
> begin
> declare tradeid int;
> set tradeid=100;
>
> select * from executions where trade_id=tradeid
>
> end

I bet you can find something useful at
http://www.google.com/search?q=mysql+variables

--
"The bullets are just his way of saying 'Keep it down, I've got a
hangover.'"
Kiki to Dr. Schlock, as seen in http://pics.sluggy.com/comics/000108a.gif

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode