RE: Goodday
Don't reply or they'll get your Email address. ;-) Regards ** * K e i t h B u r k e* ** * Experience IT Ltd * Phone : +353 1 xxx * * Unit G6 * GSM : +353 86 xxx * * Riverview Business Park * Email : [EMAIL PROTECTED] * * New Nangor Road * WWW : http://www.experience.ie * * Dublin 12 * * * Ireland * * ** -Original Message- From: Weaver, Walt [mailto:[EMAIL PROTECTED]] Sent: 10 September 2002 14:59 To: [EMAIL PROTECTED] Subject: RE: Goodday This must be a great scam. I'm starting to see'em all over the place. --Walt -Original Message- From: Ocita Gabriel [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 10, 2002 3:53 PM To: [EMAIL PROTECTED] Subject: Goodday Attn: mysql , My name is Ocita G, the manager, credit and foreign bills of Ecobank Plc. I am writing in respect of a foreign customer of my bank with account number 14-255-2004/utb/t who perished in a plane crash [Korean Air Flight 801] with the whole passengers aboard on August 6, 1997. Since the demise of this our customer, I personally has watched with keen interest to see the next of kin but all has proved abortive as no one has come to claim his funds of usd.20.5 m, [twenty million five hundred thousand united states dollars] which has been with my branch for a very long time. On this note, I decided to seek for whom his name shall be used as the next of kin as no one has come up to be the next of kin. And the banking ethics here does not allow such money to stay more than Six years, because money will be recalled to the bank treasury as unclaimed after this period. In view of this I got your contact through a trade journal after realizing that your name and country is similar to the deceased. I will give you 25% of the total. Upon the receipt of your response, I will send you by fax or e-mail the application, bank's fax number and the next step to take. I will not fail to bring to your notice that this business is hitch free and that you should not entertain any fear as all modalities for fund transfer can be finalized within five banking days, after you apply to the bank as a relation to the deceased. When you receive this letter. Kindly send me an e-mail signifying Your decision including your private Tel/Fax numbers for quick communication. Respectfully submitted, Ocita G. - 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
[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
how to find double
JF, You could try this, if I understand you correctly === SELECT count(field_name), field_name FROM table_name GROUP BY field_name HAVING count(field_name) 1 === or HAVING count(field_name) = 2 , to find records that are in there twice and no more than that. Regards ** * K e i t h B u r k e* ** * Experience IT Ltd * Phone : +353 1 xxx * * Unit G6 * GSM : +353 86 xxx * * Riverview Business Park * Email : [EMAIL PROTECTED] * * New Nangor Road * WWW : http://www.experience.ie * * Dublin 12 * * * Ireland * * ** -Original Message- From: jf Leoni [mailto:[EMAIL PROTECTED]] Sent: 06 September 2002 11:28 To: [EMAIL PROTECTED] Subject: how to find double hello, i have a table with 10 500 000 rows on a mysql database how can i find doubles ?? i know how to do it using php, but maybe there is a way using only queries? tks JF leoni - 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
RE: [MySQL] HELP: Can MySQL run external programs... Sendmail for example
Walt, Sorry, let me explain in a little more detail. I have an Access front end ODBC'd to a Foxpro database [I hate Foxpro :-p No choice, another company developed it for our customer.] on a Windows server. I get it to export the data to couple of files, tar, gzip, then ftp to my Internet server. I don't want to have to MD5 at this stage, it's so much easier to do it on the linux box. Emailing is not a problem on the Windows box. Will eventually go to VB scheduled job, or let Oracle handle the whole source data thing. Hope that clears it up a bit for ye ;-) Regards ** * K e i t h B u r k e* ** * Experience IT Ltd * Phone : +353 1 xxx xxx * * Unit G6 * GSM : +353 86 xxx xxx * * Riverview Business Park * Email : [EMAIL PROTECTED] * * New Nangor Road * WWW : http://www.experience.ie * * Dublin 12 * * * Ireland * * ** -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of walt Sent: 06 September 2002 15:05 To: [EMAIL PROTECTED] Cc: MySQL Mailing List Subject: Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for example *snip* Keith, When you say Emailing and MD5'ing at the data source.. Are you saying you dont want to use PHP to insert and email the passwords? walt - 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
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 * * Unit G6 * GSM : +353 86 xxx * * 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
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 * * Unit G6 * GSM : +353 86 xxx * * 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