Sure! Try this:
SELECT *
FROM table
WHERE 1=2
-ms
- Original Message -
From: "Scott Teglasi" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 28, 2003 10:42 PM
Subject: Getting an empty result set is what I want!
Hi all, this is Scotty.
I
Hi all, this is Scotty.
I wanted to know if it's possible to have MySQL return a resultset even
though there are no results. I want this so that I can retrieve field
information on each field that's in the query. (field type, length,
etc). I know I can use describe or show columns to get the t