Go4Expert - View Single Post - IS there any MySQL Default tables like DUAL in ORACLE.

amit_27

Hi,

I am trying to fire a query in MyLSQ 5.1.34 like

mysql> select table_schema from INFORMATION_SCHEMA.TABLES where table_name='table11';

Empty set (0.08 sec)

where table11 is not present in the INFORMATION_SCHEMA.TABLES.

I am expecting the error as table not found but as it is returning the empty set.

I tried to fire a query using mysql_real_query() API. How would I get the correct result as table not found?

Or any other ways to achieve same?

amit_27 Go4Expert Member
11Jun2009,11:03
	Hi, I am trying to fire a query in MyLSQ 5.1.34 like mysql> select table_schema from INFORMATION_SCHEMA.TABLES where table_name='table11'; Empty set (0.08 sec) where table11 is not present in the INFORMATION_SCHEMA.TABLES. I am expecting the error as table not found but as it is returning the empty set. I tried to fire a query using mysql_real_query() API. How would I get the correct result as table not found? Or any other ways to achieve same?