mysql> select database(); +------------+ | database() | +------------+ | lbox | +------------+ 1 row in set (0.05 sec)
mysql> show databases; +----------+ | Database | +----------+ | LBOX | | mysql | | test | +----------+ 3 rows in set (0.11 sec)
mysql> show tables; +----------------+ | Tables_in_lbox | +----------------+ | dtype | | dtype2 | | dtype_int | | dtype_int2 | +----------------+ 4 rows in set (0.00 sec)
mysql> show tables from mysql; +-----------------+ | Tables_in_mysql | +-----------------+ | columns_priv | | db | | dtype | | func | | host | | tables_priv | | test1 | | user | +-----------------+ 8 rows in set (0.05 sec)
mysql> show columns from dtype2; +-----------------+---------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+---------------+------+-----+---------+-------+ | MY_TINYINT | tinyint(4) | YES | | NULL | | | MY_SMALLINT | smallint(6) | YES | | NULL | | | MY_MEDIUMINT | mediumint(9) | YES | | NULL | | | MY_INT | int(11) | | PRI | 0 | | | MY_FLOAT | float | YES | | NULL | | | MY_DOUBLE | double | YES | | NULL | | | MY_DECIMAL_10_2 | decimal(10,2) | YES | | NULL | | | MY_DATETIME | datetime | YES | | NULL | | | MY_CHAR_10 | varchar(10) | YES | | NULL | | | MY_VARCHAR_10 | varchar(10) | YES | | NULL | | | MY_TEXT | text | YES | | NULL | | +-----------------+---------------+------+-----+---------+-------+ 11 rows in set (0.05 sec)