i didnt fully catch you... is this the kind of query statement you want? INSERT INTO some_other_table SELECT some_field_list FROM z_mail_systems HAVING COUNT(any_field)>0
On Tue, 19 Oct 2004 12:45:30 -0400, Josh Howe <[EMAIL PROTECTED]> wrote: > if (select count(*) from z_mail_systems > 0) then [insert statement] > endif; > > How do I do this kind of conditional insert? Thanks. > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]