On 08-Dec-2003 Srinivas B.S.S wrote:
> Hi,
>
> I am a newbie to mysql db. I need a select statement which will just
> execute and doesn't
> return any results. Also, it should not depend on any table which is
> specific to a database.
> For example, Oracle has a table named 'tab' which will be present in all
> databases so my
> dummy select statement looks like 'select tname from tab where 0=1'.
> Could this
> functionality be achieved in mysql ? Is there any table in mysql which
> is similar to Oracle's
> 'tab' ?
>
Does it have to be a SELECT? Or just a NO-OP?
SET @nothing=0;
-or-
DO 0;
- or -
SHOW TABLES LIKE 'asdfzxcv1234';
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table query)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
