Hi Keith,
It's very simple.
type from console : mysql -u root -h your_host....or whatever you need to
start mysql client and after this just type :
mysql>\P mail root@localhost;
mysql>select User,Host,Password from mysql.user;
mysql>\n;
...after this you can look in the root e-mail box and you can see the result
of query.
Indeed doesn't work with ENCAPSULATED(i don't know a better term in
english...Ufff my english) SQL QUERY
If this solution it's not what you need the alternative is UDF.
Regards,
Gelu
_____________________________________________________
G.NET SOFTWARE COMPANY
Permanent e-mail address : gg@stripped
gelugogancea@stripped
----- Original Message -----
From: "Keith Burke [Experience IT]" <kburke@stripped>
To: "'Gelu Gogancea'" <ggelu@stripped>; "'Michael T. Babcock'"
<mbabcock@stripped>; <mysql@stripped>
Sent: Friday, September 06, 2002 6:54 PM
Subject: RE: [MySQL] HELP: Can MySQL run external programs... Sendmail for
example
> Sorry, my bad.
>
> What is this PAGER and where do I run your test script from?
>
>
>
>
>
> Regards
>
> **************************************************************
> * K e i t h B u r k e *
> **************************************************************
> * Experience IT Ltd * Phone : +353 1 460 3880 *
> * Unit G6 * GSM : +353 86 600 4004 *
> * Riverview Business Park * Email : kburke@stripped *
> * New Nangor Road * WWW : http://www.experience.ie *
> * Dublin 12 * *
> * Ireland * *
> **************************************************************
>
>
> -----Original Message-----
> From: Gelu Gogancea [mailto:ggelu@stripped]
> Sent: 06 September 2002 16:39
> To: kburke@stripped; 'Michael T. Babcock'; mysql@stripped
> Subject: Re: [MySQL] HELP: Can MySQL run external programs... Sendmail
> for example
>
>
>
> ...
> > I'll also have to read up on those UDF's. Sounds interesting.
> ...or PAGER.
> Try to do a test:
>
> \P mail root@localhost;
> select User,Host,Password from mysql.user;
> \n
>
> Regards,
>
> Gelu
> _____________________________________________________
> G.NET SOFTWARE COMPANY
>
> Permanent e-mail address : gg@stripped
> gelugogancea@stripped
> ----- Original Message -----
> From: "Keith Burke [Experience IT]" <kburke@stripped>
> To: "'Michael T. Babcock'" <mbabcock@stripped>;
> <mysql@stripped>
> Sent: Friday, September 06, 2002 6:00 PM
> Subject: RE: [MySQL] HELP: Can MySQL run external programs... Sendmail
> for example
>
>
> >
> > Michael T. Babcock wrote:
> >
> > >May I rephrase your comment?
> > >
> > >"I need to send E-mails to people from MySQL data".
> > >
> > >I recommend just doing a SELECT on the data in question and
> > >generating the E-mails from PERL or PHP or whatever other language
> > >you are using.
> >
> >
> >
> >
> > No you may not ;-)
> > *joke*
> >
> > It needs to be run automatically without user intervention [cronjob]
> > so the PERL [not an option as I've never used it] or PHP would have
> > to be of the CGI variety [if that's what you call the standalone
> > version, not the API for the web server].
> >
> > But it is an option and I'll consider.
> >
> > I'll probably try the suggestion by Ralf Narozny first.
> > It seems to be exactly what I want, plus... It's relatively simple :-)
> >
> > I'll also have to read up on those UDF's. Sounds interesting.
> >
> >
> > Cheers everyone.
> >
> > Regards
> >
> > **************************************************************
> > * K e i t h B u r k e *
> > **************************************************************
> > * Experience IT Ltd * Phone : +353 1 xxx xxxx *
> > * Unit G6 * GSM : +353 86 xxx xxxx *
> > * Riverview Business Park * Email : kburke@stripped *
> > * New Nangor Road * WWW : http://www.experience.ie *
> > * Dublin 12 * *
> > * Ireland * *
> > **************************************************************
> >
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <mysql-thread118953@stripped>
> > To unsubscribe, e-mail
> > <mysql-unsubscribe-ggelu=arctic.ro@stripped>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <mysql-thread118960@stripped>
> To unsubscribe, e-mail <mysql-unsubscribe-ggelu=arctic.ro@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
