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?