OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Exists Query

From: maxdb (maxdbceroriesgo.co.cr)
Date: Mon May 10 2004 - 14:51:32 CDT


How can I implement an IF statement with a Exist predicate
ej.
if exists(select 1 from dba.mytable where mycolumnpk=1) then begin
    insert into z values (1);
end;

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb