Re: In need of a dummy select statement ...

2003-12-09 Thread Srinivas B.S.S
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

RE: In need of a dummy select statement ...

2003-12-08 Thread Cersosimo, Steve
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 n

Re: In need of a dummy select statement ...

2003-12-08 Thread Srinivas B.S.S
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

Re: In need of a dummy select statement ...

2003-12-08 Thread Don Read
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

Re: In need of a dummy select statement ...

2003-12-08 Thread Srinivas B.S.S
Thanks for the reply. As you said, we can always create one if it doesn't exist. How about using show command ? Can we execute 'show tables' command from a program using MyODBC ? If yes, can we give a pattern to 'like' which doesn't match anything. i.e. show tables like 'something which will n

Re: In need of a dummy select statement ...

2003-12-08 Thread Martijn Tonies
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 sel

In need of a dummy select statement ...

2003-12-08 Thread Srinivas B.S.S
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 stateme