03-02-2015
Here is an example when it finds something:
+--------------+---------------------+-----------------------+
| new_messages | last_purge_at | comment |
+--------------+---------------------+-----------------------+
| 3 | 2015-03-02 11:41:55 |
email@something.com |
+--------------+---------------------+-----------------------+
When it returns nothing, I get no kind of results - just a new prompt.
8 More Discussions You Might Find Interesting
1. Programming
Hi there,
I have a hierarchical database that include 4 tables. Table A is the parent of B, B is Parent of C, C is parent of D. If I want to query everything in D that is associated with A.name, how do I do that? Thanks!
YanYan (0 Replies)
Discussion started by: pinkgladiator
0 Replies
2. Shell Programming and Scripting
Hi there, I have a table that stores multiple records for many different servers, each of which is timestamped ... I wanted to write a query that would enable me to only output the "latest" record (based on timestamp) for each "unique" server. So for example my main table looks like this
... (3 Replies)
Discussion started by: hcclnoodles
3 Replies
3. Shell Programming and Scripting
I'm running a bash script query and assigning the output to a variable like this:
exists=`mysql -u $USER_NAME --password=$PASSWORD -D "somedb" \
-e "SELECT * FROM somedb.sometable WHERE field1 ='$a' \
AND field2 ='$b' LIMIT 0 , 30";`
which returns something like:
echo... (2 Replies)
Discussion started by: unclecameron
2 Replies
4. Web Development
Hi all,
I have a bit of an issue, I am working on a bit of a CMDB for a friend, it's to do with real estate.
Anyway, this is my situation.
I have a table which contains all the properties (forsale, sold, etc) in the DB named "property".
Now, this is what I want to achieve, I wish to... (5 Replies)
Discussion started by: STOIE
5 Replies
5. Web Development
hello all
i have 2 columns every column in the following format
column1
2011-04-01 11:39:54
column2
2019-02-03 00:00:00
i want get difference between above data as following
2 days 11:39
how to do so ?
i tried many functions but nothing works
please advice what is the query... (6 Replies)
Discussion started by: mogabr
6 Replies
6. Programming
Hello
i have created mysql query to compare to values and get difference in percentage
as following:
SELECT file_name, 100 - ((100 * (SELECT file_count FROM xipi_files z WHERE x.file_group = z.file_group AND x.file_name = z.file_name AND z.insert_date = CURDATE( ) - INTERVAL 1 DAY)) /... (1 Reply)
Discussion started by: mogabr
1 Replies
7. Shell Programming and Scripting
Hi, Im new with bash scripting and I want to create a conditional emailing with bash scripting. But it doesn't workout.
the conditional requirement are; if the TextDecoded value from inbox table are not the same with sms_keyword value from kontak_group table then don't email.
It keep... (10 Replies)
Discussion started by: jazzyzha
10 Replies
8. Programming
Hi All,
i have a table in mysql with the following data
Table name Test
Assettype Serial_No Status location
Mouse 123456 In Stock chennai
Mouse 98765 Allocated chennai
Keyboard ... (2 Replies)
Discussion started by: venkitesh
2 Replies
LEARN ABOUT SUSE
mailto.conf
mailto.conf(5) Apple Inc. mailto.conf(5)
NAME
mailto.conf - configuration file for cups email notifier
DESCRIPTION
The mailto.conf file defines the local mail server and email notification preferences for CUPS.
Each line in the file can be a configuration directive, a blank line, or a comment. Comment lines start with the # character.
DIRECTIVES
Cc cc-address@domain.com
Specifies an additional recipient for all email notifications.
From from-address@domain.com
Specifies the sender of email notifications.
Sendmail sendmail command and options
Specifies the sendmail command to use when sending email notifications. Only one Sendmail or SMTPServer line may be present in the
mailto.conf file. If multiple lines are present, only the last one is used.
SMTPServer servername
Specifies a SMTP server to send email notifications to. Only one Sendmail or SMTPServer line may be present in the mailto.conf file.
If multiple lines are present, only the last one is used.
Subject subject-prefix
Specifies a prefix string for the subject line of an email notification.
SEE ALSO
classes.conf(5), cupsd(8), cupsd.conf(5), mime.convs(5), mime.types(5), printers.conf(5),
http://localhost:631/help
COPYRIGHT
Copyright 2007-2009 by Apple Inc.
12 July 2006 CUPS mailto.conf(5)