Mailx recipient from mysql database Post: 302789675

Login or Register to Ask a Question and Join Our Community

Sponsored Content

Top Forums Shell Programming and Scripting Mailx recipient from mysql database Post 302789675 by ahamed101 on Thursday 4th of April 2013 04:44:43 AM

Old

04-04-2013

Registered User

Yes, but we need more modifications. I dont have a mysql setup right now. So can you paste the output of

Code:

mysql -uroot -pabcde smsd -N -s -r -e SELECT email FROM recipient

We basically want to remove the header and new line from the sql ouput.

--ahamed

---------- Post updated at 01:44 AM ---------- Previous update was at 01:42 AM ----------

Also, please check the double quotes at the end after EMAIL_ADDRESS.

--ahamed

ahamed101

View Public Profile for ahamed101

Find all posts by ahamed101

6 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

mailx recipient restriction

maybe a simple question, but i've looked around and not been able to find anything. is there a restriction on how many recipients can be used in a single mailx command? whether it's a numeric restriction or a size restriction (like 256k for the whole recipient parameter). thanks a lot.

2. Shell Programming and Scripting

Mailx Recipient and Name Script

Hi To All, I have a file with email addresses, most of which have names associated with them, it looks like this: http://img230.imageshack.us/img230/8255/94731317.th.jpg I am trying to come up with a script to use mailx (or anything else really) to send an email to...

3. UNIX for Dummies Questions & Answers

Connect MySQL database from Unix

How to connect a MySQL database from unix using unix shell scripting ( people are using perl scrpt to connect the same database). I want to access a MySQL database through a shell script

4. Shell Programming and Scripting

How to backup a particular Database in MYSQL?

Hi All, Thanks in Advance!! How to backup a particular Databases..through Bash script!! For example i have 6 databases; Anish linux Software Questions Rhce Google these are the databases i have from that i want to take "Anish" and "questions" database backup regularly....

5. Programming

Mailx recipient from mysql database

Dear All, Can I make Mailx to read recipient address from a mysql database? I already tried emailing with bash script: SUBJECT="TEST" export EMAIL_ADDRESS=`mysql -uroot -pabcde smsd -e "SELECT email FROM recipient"` mysql -uroot -pabcde smsd -e "SELECT ID, SenderName, Body FROM inbox" |...

6. Web Development

Apache users from MySQL database

Hi team, How can I implement a users in MySQL database for Apache users, assuming that I'm using RHEL6. That is to say, how can I design this database and how let's Apache server know those user in this database. Thanks in advance..

LEARN ABOUT OPENSOLARIS

isamlog

isamlog(1)							  MySQL database							isamlog(1)

NAME

       isamlog - Write info about whats in a nisam log file.

USAGE

       isamlog [-?iruvIV] [-c #] [-f #] [-F filepath/] [-o #] [-R file recordpos] [-w write_file] [log-filename [table ...]]

SYNOPSIS

       isamlog [-?|-I] [-V] [-c] [-f] [-F] [-i] [-o] [-p #] [-r] [-R] [-u] [-v] [-w]

DESCRIPTION

       isamlog

       -?|-I  info

       -V     version

       -c     do only # commands

       -f     max open files

       -F     file path

       -i     extra info

       -o     offset

       -p #   remove # components from path

       -r     recover

       -R     file recordposition

       -u     update

       -v     verbose

       -w     write file

NOTE

       If  no  file name is given isam.log is used One can give a second and a third '-v' for more verbose.  Normaly one does a update (-u).  If a
       recover is done all writes and all possibly updates and deletes is done and errors are only counted.  If one gives table names as arguments
       only these tables will be updated

SEE ALSO

       isamchk(1),   mysql(1),	 mysqlaccess(1),   mysqladmin(1),   mysqld(1),	mysqld_multi(1),  mysqld_safe(1),  mysqldump(1),  mysql_fix_privi-
       lege_tables(1), mysqlshow(1), mysql_zap(1), perror(1), replace(1)

       For more information please refer to the MySQL reference manual, which may already be installed locally and which is also available  online
       at http://www.mysql.com/doc/en/

BUGS

       Please refer to http://bugs.mysql.com/ to report bugs.

AUTHOR

       Ver  1.0,  distribution	4.0.24	Michael (Monty) Widenius (monty@mysql.com), MySQL AB (http://www.mysql.com/).  This software comes with no
       warranty.  Manual page by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mercurmedia Data Model Architect / system developer  (http://www.mercur-
       media.com)

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +--------------------+------------------------------------+
       |  ATTRIBUTE TYPE    |	       ATTRIBUTE VALUE		 |
       +--------------------+------------------------------------+
       |Availability	    | SUNWmysqlr, SUNWmysqlu, SUNWmysqlt |
       +--------------------+------------------------------------+
       |Interface Stability | External				 |
       +--------------------+------------------------------------+
NOTES

       Source for mysql is available on http://opensolaris.org.

MySQL 4.0							 19 December 2000							isamlog(1)