MySQL 127.0.0.1:4302+ ssl SQL > show schemas; +--------------------+ | Database | +--------------------+ | gts1 | | imaschema | | information_schema | | mysql | | performance_schema | | sys | | t | | t2 | +--------------------+ 8 rows in set (0.0018 sec) MySQL 127.0.0.1:4302+ ssl SQL > use gts1 Default schema set to `gts1`. Fetching global names, object names from `gts1` for auto-completion... Press ^C to stop. MySQL 127.0.0.1:4302+ ssl gts1 SQL > show tables; +----------------+ | Tables_in_gts1 | +----------------+ | tt1 | | tt2 | | tt3 | | tt4 | | tt5 | | tt6 | +----------------+ 6 rows in set (0.0015 sec) MySQL 127.0.0.1:4302+ ssl gts1 SQL > show create table tt1; ERROR: 1146: Table 'gts1.tt1' doesn't exist MySQL 127.0.0.1:4302+ ssl gts1 SQL > create table t(i int primary key); ERROR: 1062: Duplicate entry '189' for key 'tablespaces.PRIMARY' MySQL 127.0.0.1:4302+ ssl gts1 SQL > create table t(i int primary key); ERROR: 1062: Duplicate entry '190' for key 'tablespaces.PRIMARY' MySQL 127.0.0.1:4302+ ssl gts1 SQL > use t Default schema set to `t`. Fetching global names, object names from `t` for auto-completion... Press ^C to stop. MySQL 127.0.0.1:4302+ ssl t SQL > create table a(i int primary key); ERROR: 1062: Duplicate entry '191' for key 'tablespaces.PRIMARY' MySQL 127.0.0.1:4302+ ssl t SQL > show tables; +-------------+ | Tables_in_t | +-------------+ | t | +-------------+ 1 row in set (0.0015 sec) MySQL 127.0.0.1:4302+ ssl t SQL > drop table t; Query OK, 0 rows affected (0.0583 sec) MySQL 127.0.0.1:4302+ ssl t SQL > show tables; Empty set (0.0015 sec) MySQL 127.0.0.1:4302+ ssl t SQL > create table a(i int primary key); Query OK, 0 rows affected (0.0238 sec) MySQL 127.0.0.1:4302+ ssl t SQL > create table b(i int primary key); Query OK, 0 rows affected (0.0578 sec) MySQL 127.0.0.1:4302+ ssl t SQL > use gts1; Default schema set to `gts1`. Fetching global names, object names from `gts1` for auto-completion... Press ^C to stop. MySQL 127.0.0.1:4302+ ssl gts1 SQL > create table t(i int primary key); Query OK, 0 rows affected (0.0569 sec) MySQL 127.0.0.1:4302+ ssl gts1 SQL > show create table gts1\G ERROR: 1146: Table 'gts1.gts1' doesn't exist MySQL 127.0.0.1:4302+ ssl gts1 SQL > show create table tt1\G ERROR: 1146: Table 'gts1.tt1' doesn't exist