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
match anything. i.e. show tables like 'something which will not match
this possible ?
Martijn Tonies wrote:
>>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'.
>>functionality be achieved in mysql ? Is there any table in mysql which
>>is similar to Oracle's
>Not by default, but hey: you can always create one.
>Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL