Brian,

In UNIX from "mysql" prompt do:

mysql> system /bin/hostname

Mikhail



-----Original Message-----
From: Stanton, Brian [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, April 27, 2005 11:03 AM
To: 'mysql@lists.mysql.com'
Subject: host info

Does anyone know a function that will return the hostname of the mysql
server you are connecting to?

 

Just as:

mysql> select database();

returns the database you're connected to, I need to display the host I'm
connected to.

 

Similar to the oracle statement: select host_name from v$instance;

 

Thanks,

Brian Stanton

 


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to