Posted by Tobin Harris on 09/28/00 11:19

Hi there,

I'm trying to create an sql script with something like this in MySql
(4.1.1a-nt)..

if @some_var = 1 then
update blah set col = 'a';
end if;

I've tried lots of variations but can't get it to work due to syntax error.
Any ideas?

Thanks in advance

Tobes

• Next in forum: Re: Database "pruning" tool?
• Prev in forum: Re: 2 where clause in same statement Mysql 4.2
• Thread view: conditional update

[Reply to this message]