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?