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 not match
anything'. Is
this possible ?
Thanks,
Srinivas.
Martijn Tonies 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' ?
>>
>>
>
>Not by default, but hey: you can always create one.
>
>With regards,
>
>Martijn Tonies
>Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
>Server.
>Upscene Productions
>http://www.upscene.com
>
>
>
>
