From: Date: September 6 2002 6:05pm
Subject: Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for example
List-Archive: http://lists.mysql.com/mysql/118963
Message-Id: <005701c255bf$3a7d4d40$9000000a@arctic.ro>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="ISO-8859-1"
Content-Transfer-Encoding: 7bit

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
>
>