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 : [EMAIL PROTECTED] [EMAIL PROTECTED] ----- Original Message ----- From: "Keith Burke [Experience IT]" <[EMAIL PROTECTED]> To: "'Gelu Gogancea'" <[EMAIL PROTECTED]>; "'Michael T. Babcock'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> 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 : [EMAIL PROTECTED] * > * New Nangor Road * WWW : http://www.experience.ie * > * Dublin 12 * * > * Ireland * * > ************************************************************** > > > -----Original Message----- > From: Gelu Gogancea [mailto:[EMAIL PROTECTED]] > Sent: 06 September 2002 16:39 > To: [EMAIL PROTECTED]; 'Michael T. Babcock'; [EMAIL PROTECTED] > 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 : [EMAIL PROTECTED] > [EMAIL PROTECTED] > ----- Original Message ----- > From: "Keith Burke [Experience IT]" <[EMAIL PROTECTED]> > To: "'Michael T. Babcock'" <[EMAIL PROTECTED]>; > <[EMAIL PROTECTED]> > 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 : [EMAIL PROTECTED] * > > * 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 <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > > <[EMAIL PROTECTED]> > > 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 <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php