Have you considered doing what you want to do in Ant? I haven't done exactly what you want to do but Ant supports properties and conditions. I could imagine an Ant task that determines if the desired record exists, then another task that does an insert is executed only if the record doesn't exist.
That might be easier than using a programming language if you have a major reluctance to do programming. Rhino ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "Josh Howe" <[EMAIL PROTECTED]> Cc: "Leo" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, October 27, 2004 3:29 PM Subject: RE: what is wrong woth this statement? > Nearly all of the T-SQL style procedural statements (IF... BEGIN... END, > WHILE...WEND, cursors, etc.) are not currently available in MySQL. > Procedural scripts , like the one you propose, will be available in Stored > Procedures (new to MySQL 5.0+). I haven't tested that version yet, so I > can't tell you if it will support a statement like yours outside of a > stored procedure (as a stand-alone statement). > > As of right now, you still need to make control-of-flow decisions in your > programming language not your SQL statements. Sorry. > > Depending on what you are trying to do, there may be valid MySQL SQL > statement or sequence of statements that will duplicate the behavior of > the decision you are trying to make. Can you be very specific about what > action(s) you want your statement to make? > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine > > "Josh Howe" <[EMAIL PROTECTED]> wrote on 10/27/2004 03:15:11 PM: > > > Sorry, I don't think I was very clear. I'm asking a more generic > > question about control flow expressions. I want to run a sql statement > > but only if a certain condition is met, namely if a particular record > > exists in a table. I want to do it all in a single mysql statement, like > > so: > > > > If ([record exists]) then > > Do some sql > > End If > > > > How can I do this? Thanks. > > > > > > -----Original Message----- > > From: Leo [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, October 19, 2004 11:38 PM > > To: Josh Howe > > Cc: [EMAIL PROTECTED] > > Subject: Re: what is wrong woth this statement? > > > > 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] > > > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
