From: Paul DuBois At 22:27 +0200 5/16/04,
John Fawcett wrote:
Year does not operate on a unix timestamp.
Sure it does:
mysql select t, year(t) from tsdemo1;
++-+
| t | year(t) |
++-+
| 20010822133241 |2001 |
|
At 0:25 +0200 5/17/04, John Fawcett wrote:
From: Paul DuBois At 22:27 +0200 5/16/04,
John Fawcett wrote:
Year does not operate on a unix timestamp.
Sure it does:
mysql select t, year(t) from tsdemo1;
++-+
| t | year(t) |
++-+
|
Yingyos [EMAIL PROTECTED] wrote:
I type this command line.
mysql -uuser -N -eselect date_format('2004-02-29','%X') sample2.txt
When i open in text editor,it show that '2004' only.
But i want format display on text file.
mysql select date_format('2004-02-29','%X');
Hi Victor Pendleton ,
I type this command line.
mysql -uuser -N -eselect date_format('2004-02-29','%X') sample2.txt
When i open in text editor,it show that '2004' only.
But i want format display on text file.
mysql select date_format('2004-02-29','%X');
++
|
Ok, let's collect the spamming addresses:
[EMAIL PROTECTED]
[EMAIL PROTECTED] (The Oracle)
[EMAIL PROTECTED]
[EMAIL PROTECTED]
--
To Unix or not to Unix. That is the question whether 'tis nobler in the
mind to suffer slings and arrows of vast documentation or to take arms
against a sea of
Hmm
This is not nice.. I posted on this list, and within seconds I got spam from
some phone company which was a reply to my post to the list. Aparently a
company is subscribed and use posts here to build a list of valid addresses
to spam...
The offending mailer was: [EMAIL PROTECTED
are you getting spam or an autoresponder. i rarely post to this list so
lets see what happens.
Joe Baptista - only at www.baptista.god
Whenever we attack, they retreat. When we pound them with missiles
and heavy artillery, they retreat even deeper. But when we stopped
pounding, they pushed
Joe Baptista wrote:
are you getting spam or an autoresponder. i rarely post to this list
so
lets see what happens.
Both, when I get a 'requested' salespitch I call it spam, no matter if it
was auto or not. Seems I get it for every mail I post here.
Best Wishes
Thomas
--
MySQL General
Strange, I never get those!!
Marc
- Original Message -
From: Thomas Andersson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, August 23, 2003 3:41 PM
Subject: Re: Spam from this list
Joe Baptista wrote:
are you getting spam or an autoresponder. i rarely post to this list
server, i'll put it under a strict spam filter. ok,
i fortunately don't get much spam for now, but you never know.
--
Yves Goergen
[EMAIL PROTECTED]
Please don't CC me (causes double mails)
-Ursprüngliche Nachricht-
Von: Thomas Andersson [EMAIL PROTECTED]
An: [EMAIL PROTECTED]
Gesendet
Hi Thomas,
I report this stuff always to [EMAIL PROTECTED] and 20 minutes later its
gone ;-)
Best regards
Nils Valentin
Tokyo/Japan
2003 8 23 22:25Thomas Andersson :
Hmm
This is not nice.. I posted on this list, and within seconds I got spam
from some phone company which was a reply
Marc Storck wrote:
Strange, I never get those!!
I've gotten 3 after 3 posts so far, bet I'll soon get my 4:th...
Best Wishes
Thomas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
This is not spam - it's an autoreponder - so lets not get to excited here.
Joe Baptista - only at www.baptista.god
Who is this dog Franks in Qatar?
... Muhammed Saeed al-Sahaf former Iraqi Information Minister
-- Forwarded message --
Date: 23 Aug 2003 09:37:30 EDT
From
you should not bother the list with this nonsense - your concept of spam
is another persons concept of managing information. Just send them an
email to block autoreponder messages to this lists participants. If they
can;'t comply then complain to the list manager.
And this by definition
On Sat, 23 Aug 2003, Thomas Andersson wrote:
Marc Storck wrote:
Strange, I never get those!!
I've gotten 3 after 3 posts so far, bet I'll soon get my 4:th...
Best Wishes
Thomas
Now you have good reason to complain - because thats not right. An
autoresponder should only send out email
Joe Baptista wrote:
Now you have good reason to complain - because thats not right. An
autoresponder should only send out email once per email address. Repeated
sends is the sign of some twit not knowing how to operate an
autoresponder.
Yea - and very well set up autoresponders should
On Sat, 23 Aug 2003, Jakob [iso-8859-1] Dölling wrote:
BTW, did anyone around here get mail from CServe containing important email
addresses such as support? I got from them these mails twice to three times
or so. Just wondering...
i've been getting email from something called the oracle.
I've been getting autoresponders from
[EMAIL PROTECTED]
[EMAIL PROTECTED] (The Oracle)
[EMAIL PROTECTED]
On Saturday, August 23, 2003, at 12:41 PM, Joe Baptista wrote:
BTW, did anyone around here get mail from CServe containing important
email
addresses such as support? I got from them these
Everytime I post to this list I get a message from
AntiSpam UOL [EMAIL PROTECTED]
My message is getting to the list ok I keep getting this annoying
message.
Kim Mackey
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
At 21:35 -0400 7/30/03, Kim Mackey wrote:
Everytime I post to this list I get a message from
AntiSpam UOL [EMAIL PROTECTED]
My message is getting to the list ok I keep getting this annoying message.
Kim Mackey
I reported this to [EMAIL PROTECTED]
That subscriber's been removed.
--
MySQL
]
Sent: Wednesday, July 30, 2003 6:38 PM
Subject: Re: What is causing me to get this anti spam message
At 21:35 -0400 7/30/03, Kim Mackey wrote:
Everytime I post to this list I get a message from
AntiSpam UOL [EMAIL PROTECTED]
My message is getting to the list ok I keep getting this annoying
It's not bad enough that we have subscribers with challenge-response
systems misconfigured so that they respond to each message from the
list. Now one of the list admins is apparently doing something
similar. At present rates of growth, it will be interesting to see
whether spam or anti-spam
rates of growth, it will be interesting to see
whether spam or anti-spam responses end up flooding the e-mail system
more.
[snip]
If you are subscribed to a MYSQL Discussion group please ignore this
email You are still subscribed to the service. Your email is not
getting to one of our MYSQL
of growth, it will be interesting to see
whether spam or anti-spam responses end up flooding the e-mail system
more.
As Mark Matthews pointed out, this message is not from one of the list
administrators.
Whenever you receive a message like this, please forward it to
[EMAIL PROTECTED
Hi,
I'm not sure what list this should go to, so I'm sending it to the general
list. It's not about sql or queries it's more of a webmaster problem.
Apologies to the offended.
After sending several messages to the list I started receiving strange
messages. It may be spam, it may be just
receiving posts? He's adding
EVERYONE who posts to his spam lists.
--
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18, 168 Walker Street
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: www.nusconsulting.com
Dear Daniel,
Thanks for taking an interest in spam fighting. I have passed this
information on to our list manager. He will do what he can to deal with
this problem.
In the future, please keep several things in mind:
- we do not tolerate name calling based on religeon, race, sexual
I don't understand why I'm getting so much spam
from the mysql list...
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 18 Dec 2002, Jeremy Zawodny wrote:
But, yeah, I agree. There are better ways to do this on the mail server
side.
Yes, and it's on our list-admin's TODO to move this list to another list
server very soon. Please be patient for just a
to the no-spam-check list instead.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
(depending on your mail distribution method)
to allow subscribers to post without going through the filter and only
filter unsubscribed people.
PPS, you could always make it database-driven and add people who post
successfully more than once a week to the no-spam-check list instead
On Wed, Dec 18, 2002 at 02:37:14PM -0500, Michael T. Babcock wrote:
Just for anyone who cares (or cares to do the same), when I reply to
messages at my average 80wpm and hit send, I don't check if
SQL,QUERY,etc. is in the message 90% of the time. Now, besides
thanking the crew for adding a
easily (and, more
importantly, is changable without changing your queries).
rantAs for spam filters, evidently the above does not contain SQL or QUERY.
It does, however, contain ALTER TABLE, QUERIES and SMALLINT, none
of which would occur outside a SQL related list with any frequency. Please
On 23 Nov 2002 12:49:33 -
[EMAIL PROTECTED] wrote:
SPAM: Start SpamAssassin results
-- SPAM: This mail is probably spam. The original
message has been altered SPAM: so you can recognise or block similar
unwanted mail in future. SPAM: See http
On 23 Nov 2002 12:54:52 -
[EMAIL PROTECTED] wrote:
SPAM: Start SpamAssassin results
-- SPAM: This mail is probably spam. The original
message has been altered SPAM: so you can recognise or block similar
unwanted mail in future. SPAM: See http
It seems they are using SPEWS (www.spews.org).
A rude way to find out that our ISP has a problem with the IP address they
gave us :-{
--
From: MySQL [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: Spam
Reply-To: [EMAIL PROTECTED]
Message-Id: [EMAIL PROTECTED]
Date: Tue, 24 Sep
-- mysql, query
I wonder if you're using any RBL to avoid spam.
They're quite effective, since most of spam comes from
open relays or misconfigured proxies.
Regards
-
Before posting, please check:
http://www.mysql.com
Gabriele Carioli wrote:
-- mysql, query
I wonder if you're using any RBL to avoid spam.
They're quite effective, since most of spam comes from
open relays or misconfigured proxies.
On this note, may I beg for a meta-list for the discussing of the
management of mysql.com's lists in general
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
(http://www.ezmlm.org)
Date: Tue, 24 Sep 2002 12:07:14 +0200 (CEST)
From: Gabriele Carioli [EMAIL PROTECTED]
-- mysql, query
I wonder if you're using any RBL to avoid spam.
They're quite effective, since most of spam
Hi All,
Due to security reasons we have to implement an audit functionality in our
MySQL production databases.
Q; Is there an audit feature in MySQL. If YES can someone send me the
information how to implement this.
Thanks,
Imro Strok
StarHub Pte Ltd
Information Technology
Phone: +65 6825 5703
Try http://www.mysql.com/doc/en/Query_log.html
-Original Message-
From: Imro Benito STROK [mailto:[EMAIL PROTECTED]]
Sent: 23 September 2002 20:04
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'; Imro Benito STROK
Subject: SPAM *** Audit feature in MySQL ***
Hi All,
Due
I hope everyone grabs the headers from that message (and any other spam
they receive) and reports it to spamcop.net to help us all block these
people.
PS, this has nothing to do with MySQL, Databases or ACID compliance, but
this line should ironically get me past the spam filter
Amit,
I am trying to run the following query:-
select red,green,blue from colorchanger where
colorcode = select value from jobattributekit where
attributekit = Color and jobnumber =
28200124RB4-001 and scenario=JN75K;
It doesn't support subselects. It's having a problem with the second
Dave
[ mysql query]
when I installed mysql 3.23.43 it instructed me to be sure to add a password with
the following results-
:
seaport2:/# /usr/mysql/bin/mysqladmin -u root -p password 'new-password'
Enter password:
/usr/mysql/bin/mysqladmin: connect to server at 'localhost' failed
List,
I'm looking for a developer in eastern Massachusetts with the following
skills to work on some ongoing projects:
MySQL
Oracle
CGI
Perl
PHP
Java
JSP
C++
This is a contract position. Resumes can be sent to
[EMAIL PROTECTED]
Hi!
As you can see below, SpamAssassin tags messages from the MySQL list as
spam. The main reason that this happens, is:
SPAM: Hit! (3.5 points) URI: URL of page called unsubscribe
That's because:
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Would it be possible
On 6 May 2002, at 7:56, Alexander Skwar wrote:
As you can see below, SpamAssassin tags messages from the MySQL list as
spam. The main reason that this happens, is:
SPAM: Hit! (3.5 points) URI: URL of page called unsubscribe
It seems to me that that's a problem with SpamAssassin
On Mon, May 06, 2002 at 07:56:10AM +, Alexander Skwar wrote:
Hi!
As you can see below, SpamAssassin tags messages from the MySQL list as
spam. The main reason that this happens, is:
SPAM: Hit! (3.5 points) URI: URL of page called unsubscribe
Well, you can add local rules
HUH ?
Oh well lets try again, please read below ...
SQL = SELECT help FROM mysql.list WHERE spam NOT LIKE 'bounce%'
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your
HUH ?
Oh well lets try again, please read below ...
SQL = SELECT help FROM mysql.list WHERE spam NOT LIKE 'bounce%'
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your
alter table your_table add unique index (path_id,word) ;
-Message d'origine-
De : Jon Shoberg [mailto:[EMAIL PROTECTED]]
Envoyé : mardi 5 février 2002 16:40
À : [EMAIL PROTECTED]
Objet : Spam Filtered - Re: Making Unique Pairs ??
HUH ?
Oh well lets try again, please read below
- Original Message -
From: Marjolein Katsma [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [RegSoft/mysql]
[EMAIL PROTECTED]; MySQL
[EMAIL PROTECTED]
Sent: Saturday, January 12, 2002 12:44 PM
Subject: RE: Spam - a possible cause ?
Matthew,
snip
Spam is people not interested in MySQL at all
snip
Spam is people not interested in MySQL at all posting a Business
opportunity (Dear mysql, Join today for FREE and a chance to win a $100
Shopping Spree at The DHS Club Outlet Center!) or Golden Investment
Opportunity or Great Growth Potential stock scams.
Marjolein,
They sound
] [RegSoft/mysql]
[EMAIL PROTECTED]; MySQL
[EMAIL PROTECTED]
Sent: Saturday, January 12, 2002 12:44 PM
Subject: RE: Spam - a possible cause ?
Matthew,
snip
Spam is people not interested in MySQL at all posting a Business
opportunity (Dear mysql, Join today for FREE and a chance to win a $100
Matthew,
Posting simple questions, even different people repeatedly posting simple questions is
NOT spam. It may be a problem for some people, but it is not what this discussion is
about.
Spam is people not interested in MySQL at all posting a Business opportunity (Dear
mysql, Join today
of the continuing spam
should give the administrators (and you ) a clue. Wouldn't they rather lose the
spammers than valuable list members?
If you raise the noise ratio from .5% to 2.5% by whining
so much, who is really the problem?
The list management - because they do not limit posting
, is a plus to me. So
what if I get a spam mail from it every now and then.
I think the list mom/dad does a good job, considering
the figurative mom/dad is a machine.
I hate to even make any comments on this because of the
amount of resources used to send this one email which
has been generated
While I don't like the idea of limiting messages to subscribers (I hate
signing up for things, especially when I'm only going to post a few
messages), I think it's still very important. Like any other problem,
ignoring it will only send a message of passive acceptance and the amount of
spam
ummm. you go ahead with that and noone will stay on the list.
again, now with my stupid reply, there has been more posts about spam
than actual spam.
let's do the list a favor and put this thread to bed.
jOda
-Original Message-
From: Patrick Crowley [mailto:[EMAIL PROTECTED]]
Sent
A little higher barrier to entry, even for non-spam posts might not be
a bad thing. The list is already pretty well spammed with questions
that are either in the manual, or result from a lack of programming
experience in general.
Making it harder to post might make it a little easier to stay
i don't consider questions resulting from a lack of programming experience
spam. the list SHOULD aid and embrace novice users. i know heikki and sinisa
have both helped me with my basic questions, although i took some time to
look in the archives and man before i posted. this IS the general list
I wasn't trying to say that the simple questions are spam, only that if
it took a little more effort to post, some people might check with the
manual and archives first. Posting to the list would always still be an
option if those failed.
Maybe the lists could be divided into: 1. mysql
2002 19:55
To: jds; Patrick Crowley; Keith C. Ivey
Cc: MySQL List
Subject: RE: Spam
A little higher barrier to entry, even for non-spam posts might not be
a bad thing. The list is already pretty well spammed with questions
that are either in the manual, or result from a lack of programming
On 10 Jan 2002, at 10:32, Marjolein Katsma wrote:
The list is too valuable for me to leave - but it really SHOULD be
subscription only.
Of course it should be. Every other big list I'm on is subscriber-
only and doesn't have these spam problems, or the annoyance of the
filter (which I hope
At 18:15 10/01/2002, you wrote:
I have to say I'm shocked that the list is completely open. That's such a
stupid newbie thing to do.
maybe they think their filter is OK :
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter
On 10 Jan 2002, at 18:48, Thibaut Allender wrote:
maybe they think their filter is OK :
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
database
Keith C. Ivey wrote:
On 10 Jan 2002, at 18:48, Thibaut Allender wrote:
maybe they think their filter is OK :
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words
well said!!
generously indeed...
soft, fuzzy rtfmS are badly needed.
-Original Message-
From: Steve Rapaport [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 10, 2002 12:46 PM
Cc: [EMAIL PROTECTED]
Subject: Heads up re Spam.
Okay guys, let's not get our panties in a twist.
I've
At 19:46 2002-01-10, Steve Rapaport wrote:
Okay guys, let's not get our panties in a twist.
I've just scanned through the last 1500 postings and
come up with about 7 spams. On the other hand there
have been at least 4 times that amount of messages
griping about spam, which you will acknowledge
[EMAIL PROTECTED] writes:
HTML
I'm getting seriously sick of the amount of spam on this list.
I don't know what MySQL employee is responsible for managing
this list, but assuming that there is such a person, could
he/she _please_ do something about the problem? When every
other list owner can
Reported to SpamCop.net
At 15:54 2002-01-08, Carl Troein [EMAIL PROTECTED] [RegSoft/mysql] wrote:
[EMAIL PROTECTED] writes:
HTML
I'm getting seriously sick of the amount of spam on this list.
I don't know what MySQL employee is responsible for managing
this list, but assuming
Personnaly I found no particular spam on this list, in the beginning of the
year I found article dated to the 01/01/2003 and not the 01/01/2002, this
message was refused cause it doens t contain
words like sql
I thinks that my mail client wich doesn work well (hum outlook
, but sadly enough the spam part is true for this list as
well. I completely agree with whomever proposed to have this
list modified to accept mails from subscribed people only
An alternative that has just been implemented on the PHP lists is to
keep an approved list of addresses in addition
Hi,
The TurboPower new groups (news://news.turbopower.com) seem to work fine,
with little spam. Because they host the news groups themselves, there is no
problem with them not being hosted by a particular ISP.
It would be really nice to have a new group, but the ground has been covered
so many
From other mailings on the list and my own experience, it seems
[EMAIL PROTECTED] is (has been?) sending these out to any poster
to the list.
If things aren't fixed yet, I'll probably have another one in a couple of
minutes...
Anyhow, no SJS, it seems to me this 'no spam' crap has nothing
to do
]
Subject: RE: RE: spam
From other mailings on the list and my own experience, it seems
[EMAIL PROTECTED] is (has been?) sending these out to any poster
to the list.
If things aren't fixed yet, I'll probably have another one in a couple of
minutes...
Anyhow, no SJS, it seems to me this 'no spam' crap
I am new to the list, and have only asked two questions. However, when I post I seem
to get a message back from [EMAIL PROTECTED] about not wanting me to spam. Am I doing
something wrong here? Does anyone else get this message as well?
Thanks,
SJS
101 - 177 of 177 matches
Mail list logo