|
Programming C, bash, Python, Perl, PHP, Java, you name it. |
|
Thread Tools | Display Modes |
|
|||
Show default MySQL database
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:
Code:
-- MySQL show current, default or database in use ... select "Current database in use ...." union select database() ; Code:
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
__________________
You don't need to be a genius to debug a pf.conf firewall ruleset, you just need the guts to run tcpdump |
Tags |
mysql default database |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
MySQL database import not helpful | J65nko | General software and network | 2 | 10th December 2011 02:45 AM |
Read Excel Data and store into Mysql Database using PHP | cksraj | Programming | 2 | 3rd June 2009 12:09 PM |
Roundcube Mail Can't Connect to MYSQL Database | jrs665 | OpenBSD Packages and Ports | 1 | 17th November 2008 03:54 PM |
mplayer do not show subtitle | mfaridi | OpenBSD Packages and Ports | 3 | 12th November 2008 05:41 AM |
Changing encoding of text in MySQL database | stukov | Programming | 5 | 15th July 2008 09:48 PM |