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. :-)



Jeremy D. Zawodny     |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]>  |  http://jeremy.zawodny.com/

MySQL 4.0.13: up 3 days, processed 123,944,602 queries (394/sec. avg)



-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com

Are you MySQL certified? http://www.mysql.com/certification/


-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to