You are welcome. But remember that sometimes it truncates the name. For example I sometimes connect from my laptop using nzeyimana as username and it just returns [EMAIL PROTECTED] instead of returning [EMAIL PROTECTED] (it just removes the last P).
I don't know why. Maybe someone on the list may help on this issue. Also as I told you, I don't know the difference between USER() and SESSION_USER() Thanks Emery ----- Original Message ----- From: "Chris Faust" <[EMAIL PROTECTED]> To: "Director General: NEFACOMP" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, October 20, 2003 15:27 Subject: Re: Getting remote connected machine as value in a select. > Thanks Emery, > > That is exactly what I needed, it gives me back the IP of the machine I'm > connecting from. > This is going to allow me to remove so much machine specific code that we > could put up a new server within mins if needed. > > Thanks Again > -Chris > > ----- Original Message ----- > From: "Director General: NEFACOMP" <[EMAIL PROTECTED]> > To: "Chris Faust" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Monday, October 20, 2003 4:38 AM > Subject: Re: Getting remote connected machine as value in a select. > > > > I don't know I well understand your problem. > > There is a function SESSION_USER() in MySQL that returns the currently > > connected user. The user string also returns the host from which he > > connected in the form [EMAIL PROTECTED] > > > > So, by issuing the query: > > SELECT SESSION_USER(), Table.* from Table > > you will get the needed data. > > > > But the problem is that you will need to get the host name from that > > username. Also it truncates the string when it is long > > There is also USER() that returns the same [EMAIL PROTECTED] . I really don't know > > the real difference between the two functions. > > > > > > Hope this helps > > > > > > Thanks > > Emery > > ----- Original Message ----- > > From: "Chris Faust" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Sunday, October 19, 2003 23:55 > > Subject: Getting remote connected machine as value in a select. > > > > > > Hello, > > > > I'm curious as to if something is possible - I don't know if its possible > to > > explain it right. > > > > I have a table which contains a bunch machine specific information, file > > paths, names etc. > > > > What I would like to try and accomplish is when I query this table for the > > information I need, I also receive back a value (that I can define) that > is > > determined by the identity of the machine making the query - either by IP > > address or whatever. > > > > For an example say I have 3 machines total. > > 1 mySQL DB Server > > 2 web servers > > > > When I connect to mySQL from either of the 2 web servers and say something > > like "Select * from table", one of the values returned would be something > > like "web1" as that is what I defined to be the value for when machine > > 192.168.0.4 connected to it. > > It doesn't have to be IP, I'm just using that for a example. > > > > Any ideas on how to accomplish something like this? > > mySql 4.0 > > RH 9 > > > > Thanks > > -Chris > > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
