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. :-)
Yeah, but not a "real" one. And there is no FROM clause.
I guess I'm not sure what the poster is "really" after here.
Hmmm.
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<Jeremy@stripped> | http://jeremy.zawodny.com/
MySQL 4.0.13: up 3 days, processed 124,187,843 queries (393/sec. avg)
