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