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]
