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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
