Show default MySQL database

[J65nko]

With MySQL you can easily switch between databases. The following SQL snippet allows you to make sure that you are working with the correct database:

-- MySQL show current, default or database in use ...

select "Current database in use ...." 
 union
select database() ;

Example:

mysql> source show-use ;
+------------------------------+
| Current database in use .... |
+------------------------------+
| Current database in use .... |
| Siralas2013                  |
+------------------------------+
2 rows in set (0.00 sec)

mysql> use Siralas2012 ;
Database changed

mysql> source show-use ;
+------------------------------+
| Current database in use .... |
+------------------------------+
| Current database in use .... |
| Siralas2012                  |
+------------------------------+
2 rows in set (0.00 sec