xupeng@localhost [(none)] mysql> use test;
Database changed
xupeng@localhost [test] mysql> create table testing (type tinyint) engine=innodb;
Query OK, 0 rows affected (0.26 sec)

xupeng@localhost [test] mysql> show tables;
Empty set (0.00 sec)

xupeng@localhost [test] mysql> show tables from information_schema;
Empty set (0.00 sec)

xupeng@localhost [test] mysql> select table_name from information_schema.tables where table_schema='test';
+------------+
| table_name |
+------------+
| testing    | 
+------------+
1 row in set (0.00 sec)

xupeng@localhost [test] mysql> insert into testing values (1);
Query OK, 1 row affected (0.04 sec)

xupeng@localhost [test] mysql> select * from testing;
+------+
| type |
+------+
|    1 | 
+------+
1 row in set (0.00 sec)