Hi, I think youd should make an UDF which that execute in shell what you need.
Regards, Gelu _____________________________________________________ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] ----- Original Message ----- From: "Keith Burke [Experience IT]" <[EMAIL PROTECTED]> To: "MySQL Mailing List" <[EMAIL PROTECTED]> Sent: Friday, September 06, 2002 1:23 PM Subject: [MySQL] HELP: Can MySQL run external programs... Sendmail for example > Greetings, > > I'm new to this list but not to MySQL. I've been using MySQL on > Linux with PHP for the past year or two. I've always managed to sort out > any problems by looking at the documentation on the website but my > current problem has me perplexed. > > > I need to be able to send Emails to people from MySQL command > line. > > > I'm importing a text file of users via a cronjob. MySQL process > the data and segragates it into different tables. My problem is that I > want MySQL to Email the plain text passwords to the users before it > MD5's them. I cannot find any references that MySQL can run external > programs [sendmail]. > > Any help or workarounds [no matter how crazy ;-)] would be appriciated, > although I'd rather not do the Emailing and MD5'ing at the data source. > > Oh, if this isn't the correct mailing list to post this, just let me > know. > > > > > > Regards > > ************************************************************** > * K e i t h B u r k e * > ************************************************************** > * Experience IT Ltd * Phone : +353 1 460 3880 * > * G6 * GSM : +353 86 600 4004 * > * Riverview Business Park * Email : [EMAIL PROTECTED] * > * New Nangor Road * WWW : http://www.experience.ie * > * Dublin 12 ************************************ > * Ireland * R a n g e R * > ************************************************************** > * Lieutenant, Your men are already dead * > ************************************************************** > > > > > --------------------------------------------------------------------- > 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