worked exactly as I
> > hoped!
> >
> > Thanks
> > -Chris
> >
> > ----- Original Message -
> > From: "Director General: NEFACOMP" <[EMAIL PROTECTED]>
> > To: "Chris Faust" <[EMAIL PROTECTED]>;
> > <[EMAIL PROTE
t; 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: &
on my dev server and everything worked exactly as I
hoped!
Thanks
-Chris
- Original Message -
From: "Director General: NEFACOMP" <[EMAIL PROTECTED]>
To: "Chris Faust" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, October 20, 2003 9:48 AM
Subject:
TECTED]>
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 mach
t;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 pro
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
yo
