You need not select a table in MySQL as you do in Oracle. Select 2 + 2; Is valid in MySQL and should return 4. It at least lets you know if MySQL is functional. By mysqladmin ping will do that too.
Steve Cersosimo [EMAIL PROTECTED] Bellsouth Internet Services "When all is said and done, more is said than done" -----Original Message----- From: Srinivas B.S.S [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 1:22 AM To: Don Read Cc: [EMAIL PROTECTED] Subject: Re: In need of a dummy select statement ... Thanks for the reply. It just have to be no-op and it need not necessarily be a select statement. Any one of the options given by you will work for me if they are executable from a program written using MyODBC. Thanks, Srinivas. Don Read wrote: >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, > > ***** "The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential, proprietary, and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all computers." 113 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]