Bernd,
> : host lists-mx.mysql.com[137.254.60.71] said: 552 spam
> score exceeded threshold (#5.6.1) (in reply to end of DATA command)
>
> Any ideas ?
Whatever provider you are using to send mail has been blacklisted?
It happens with some ISP who are not diligent enough to remove the
spammer
t; Geschäftsführer: Dr. Bernd Reifenhäuser, Dr. Alexander Ebbes
> Handelsregister: HRB 6870 - Amtsgericht Mainz
>
>
>
>
> -Ursprüngliche Nachricht-
> Von: Olivier Nicole [mailto:olivier.nic...@cs.ait.ac.th]
> Gesendet: Mittwoch, 29. April 2015 07:21
> An: mog...@fumlersoft.d
Lucio,
>> I have a table where each record is made of one item_number and one
>> data_value.
> You do not have any other column ? In particular you do not have any
> unique key record identifier ? All my tables have a column with a record
> sequence number "seq int NOT NULL AUTO_INCREMENT" whic
Thank you,
> SELECT * FROM test
> WHERE item_number in (SELECT item_number FROM test where data_value=1)
> AND item_number not in (SELECT item_number FROM test where data_value = 2);
That did it.
Olivier
> On Wed, April 29, 2015 07:20, Olivier Nicole wrote:
>>> SELE
> SELECT * FROM table WHERE item_number=1;
Sorry if my question was not clear: what I am looking for is:
SELECT * FROM table WHERE data_value=1 AND "there is not any reccord with
the same item_number and data_value=2"
Olivier
>
> On Wed, April 29, 2015 06:30, Olivier
Hi,
I am sure that it is feasible with MySQl, and I am sure that's a newbie
question, but my SQL skills are limited...
I have a table where each record is made of one item_number and one
data_value.
If one item has several values, there are several records with the same
item_number and a differe
Paul,
You could look for a tool called "The Regex Coach". While it is mainly
for Windows, it runs very well in vine. I fijd it highly useful to debug
regexps.
Best regards,
Olivier
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists
HI,
I am running MySQL 5.5.31 on FreeBSD 9.2. I have a web server with a
miss-configured service that generates faulty connections. After a
while, MySQl blocks any connection from the web server.
At some stage, I had set-up a script that would browse syslog log and
look for a string like "Host 'x
