List:General Discussion« Previous MessageNext Message »
From:Pete Harlan Date:June 6 2003 10:59pm
Subject:Re: SQL no-op?
View as plain text  
On Fri, Jun 06, 2003 at 05:19:20PM -0500, Paul DuBois wrote:
> At 15:11 -0700 6/6/03, Jeremy Zawodny wrote:
> >On Fri, Jun 06, 2003 at 04:15:29PM -0500, Mark Rages wrote:
> >> I need a placeholder statement that does nothing.
> >>
> >> Is there something more elegant than
> >> SELECT FROM ... WHERE 0=1; ?
> >>
> >> I need this because PHP throws an error when an empty statement
> >> (or just a ';') is passed to MySQL.
> >
> >SELECT 1;
> >
> >?
> >--
> 
> That returns a row, though. :-)

SET @ignore_me = 0;

?

--Pete
Thread
SQL no-op?Mark Rages6 Jun
  • Re: SQL no-op?Jeremy Zawodny7 Jun
    • Re: SQL no-op?Paul DuBois7 Jun
      • Re: SQL no-op?Jeremy Zawodny7 Jun
      • Re: SQL no-op?(Pete Harlan)7 Jun
        • Re: SQL no-op?Paul DuBois7 Jun
  • Re: SQL no-op?Becoming Digital7 Jun
    • Re: SQL no-op?Mark Rages7 Jun