Re: find any row with NULL

On 09/07/16 14:13, Hal.sz S.ndor wrote: 2016/07/08 09:15 ... Johan De Meersman: You will have to repeat all the column names - no wildcards in where clause fieldnames - but the clause you're looking for is WHERE field IS NULL. Or IS NOT NULL if you want those:-) Well, one could try this:

Re: check_mysql_health poll

the check_mysql_health nagios plug-in, is currently re-factoring the code and has a poll open about whether to change the logic behind the query cache hit rate, and to what. The poll (and check) are at https://labs.consol.de/nagios/check_mysql_health/ . /Johan - Original Message - > F

Re: check_mysql_health poll

On 7/15/2016 6:58 AM, Johan De Meersman wrote: Hey, I just happened upon your poll, so I'm sending you brief mail because I have a different opinion still :-) I'm also CCing the MySQL list, as I feel that more input on this might be a good thing - and it's worth some exposure anyway. I

Re: find any row with NULL

- Original Message - > From: "Sándor Halász" <h...@tbbs.net> > Subject: Re: find any row with NULL > > from information_schema.columns where (table_schema, table_name, You could, but information_schema queries can get pretty slow on large databases, espec

Re: Query interruption with MySQL 5.7 using KILL QUERY in signal handler does no more work

I did the following test: My program still uses MySQL 5.7 libmysqlclient.so, but I connect now to a 5.6.16 server. And the SQL interrupt works fine... so I suspect there is a MySQL server issue in 5.7. Seb On 07/12/2016 01:01 PM, Sebastien FLAESCH wrote: About: > B) For some reason, the

Re: Query interruption with MySQL 5.7 using KILL QUERY in signal handler does no more work

About: > B) For some reason, the program does not want to exit() - (must investigate) In fact we use prepared statements with a sequence of mysql_stmt_init, mysql_stmt_prepare, mysql_stmt_execute, mysql_stmt_fetch, ... and mysql_stmt_close. After the statement was interrupted, we try to free

Re: find any row with NULL

2016/07/08 09:15 ... Johan De Meersman: You will have to repeat all the column names - no wildcards in where clause fieldnames - but the clause you're looking for is WHERE field IS NULL. Or IS NOT NULL if you want those:-) Well, one could try this: set @sel=(select 'SELECT ' ||

Re: find any row with NULL

On 7/8/2016 9:15 AM, Johan De Meersman wrote: As a clear example of what it is useful for, imagine a situation where you're performing an inventory on an existing warehouse. You have the list of all the products they've ever sold, but you need to differentiate between 'this product is not in

Re: find any row with NULL

You will have to repeat all the column names - no wildcards in where clause fieldnames - but the clause you're looking for is WHERE field IS NULL. Or IS NOT NULL if you want those :-) Remember, NULL is a special value that is not the same as zero or the empty string; nor to itself: NULL !=

Re: parallel installations of mysql

> From: Reindl Harald > > Am 03.07.2016 um 04:47 schrieb Martin Mueller: >> If port 3306 is taken, how is one supposed to know that 3307 is a good >> alternative? Why not 3317 or 3703 > > seriously? > > when this is your point about bad documentation than you just

Re: parallel installations of mysql

Am 03.07.2016 um 04:47 schrieb Martin Mueller: If port 3306 is taken, how is one supposed to know that 3307 is a good alternative? Why not 3317 or 3703 seriously? when this is your point about bad documentation than you just don't have a point - there is no "good alternive". ist's only a

Re: parallel installations of mysql

Thanks. That’s helpful and makes me think that there may be a “Mac hole” in the MySQL documentation. Windows is one thing and Linux another. OS X is sort of Unix, but only sort of, and the conventions are not as firmly established. For instance, the instructions for the MySQl Sandbox—on the

Re: parallel installations of mysql

Am 03.07.2016 um 00:49 schrieb Martin Mueller: After struggling for several hours with installing an alternate installation of MySQL, I’ve concluded that this may be beyond my feeble powers but also that the official instructions are not very good. They are written for system administrators

Re: parallel installations of mysql

2016/07/02 18:49 ... Martin Mueller: It’s clear from Section 6.6 of the Reference manual that I need to make sure that the new installation differs from the old one with regard to the data directory, the port number, the socket, the shared memory-base-name, and the pid-file. It’s less clear

Re: parallel installations of mysql

Dear Mr. Green, After struggling for several hours with installing an alternate installation of MySQL, I’ve concluded that this may be beyond my feeble powers but also that the official instructions are not very good. They are written for system administrators who are doing work of this kind

Re: corrupt INNO table

Am 02.07.2016 um 16:49 schrieb Martin Mueller: I run MySQL 5.6 on OS 10.11. There is a table that appears to be corrupt: it does not respond to queries, and the command to drop it does not execute. The database seems to be OK in other respects. What can I do to get rid of the table? Would

Re: signal handling in mysql cli

d. Is there a way to make it behave like the interactive version ? Now it is a bit confusing for everyone. re, wh You did not KILL the entire client session(CONNECTION), you only killed the QUERY that the session was executing. The client remains connected and the session remai

Re: signal handling in mysql cli

i looks like that but "show full processlist;" shows otherwise and that is true as a list of long running querys showed. Is there a way to make it behave like the interactive version ? Now it is a bit confusing for everyone. re, wh -- MySQL General Mailing List For li

Re: signal handling in mysql cli

uerys showed. Is there a way to make it behave like the interactive version ? Now it is a bit confusing for everyone. re, wh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: signal handling in mysql cli

ql -BAN -e "select now(); select sleep (100) ; select now() " i looks like that but "show full processlist;" shows otherwise and that is true as a list of long running querys showed. Is there a way to make it behave like the interactive version ? Now it is a bit confusing for e

Re: signal handling in mysql cli

uerys showed. Is there a way to make it behave like the interactive version ? Now it is a bit confusing for everyone. re, wh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: Precautions to not run out of disk space?

Am 21.06.2016 um 09:41 schrieb Götz Reinicke - IT Koordinator: we recently had a software bug who wrote gigs of data to our database in a loop and finally filled the whole system. O.K. we could serverside use a separate partition/storage for the database directory, but I was wondering is mysql

Re: call the appropriate and correct database

- Original Message - > From: "HaidarPesebe" > Subject: call the appropriate and correct database > How do I call first database table as follows : > > id | country | province | distric | cost > > 1 | USA |

Re: understanding the binlog

- On May 20, 2016, at 8:38 PM, Bernd Lentes bernd.len...@helmholtz-muenchen.de wrote: > Hi, > > i'm currently creating a replication and got in contact with the binlog. I use > row-based logging. I read already the doc but i still have some questions. > Maybe you can help me. > > An

Re: Adding values returned by GREATEST

2016/05/14 16:23 ... shawn l.green: > ... If the numeric > value is quoted, it is still interpreted as an index if there is no > matching string in the list of enumeration values. One of the many cases where I believe that MySQL s attempt to be helpful by converting is not helpful. Thus it

Re: Adding values returned by GREATEST

On 5/14/2016 2:57 PM, Peter Brawley wrote: On 5/14/2016 11:16, shawn l.green wrote: Hello Sukhjinder, On 5/3/2016 8:55 AM, Sukhjinder K. Narula wrote: Hello, i have a question regarding the GREATEST function of mysql. I would like to add the values returned by GREATEST function is mysql,

Re: Adding values returned by GREATEST

On 5/14/2016 11:16, shawn l.green wrote: Hello Sukhjinder, On 5/3/2016 8:55 AM, Sukhjinder K. Narula wrote: Hello, i have a question regarding the GREATEST function of mysql. I would like to add the values returned by GREATEST function is mysql, so a query is like below: For example table t

Re: Adding values returned by GREATEST

Hello Sukhjinder, On 5/3/2016 8:55 AM, Sukhjinder K. Narula wrote: Hello, i have a question regarding the GREATEST function of mysql. I would like to add the values returned by GREATEST function is mysql, so a query is like below: For example table t has 6 fields with values as follows: A =

Re: utf8 options under Mysql

2016/04/22 04:49 ... Jigal van Hemert: It works for a lot of Western European languages very well, but in some cases there are problems. For Asian languages there are a lot more problems. For example, 'ß' isn't considered the same as 'ss'. Well, the former is an sz-ligature, and the latter is a

Re: slave to master

On 4/30/2016 3:22 AM, Thomas wrote: Am Freitag, 29. April 2016, 14:49:57 schrieb william drescher: On 4/28/2016 5:20 PM, Thomas wrote: Hi, I have setup an master slave replication. This works fine. I have running an Apache webserver and some other programms accessing the master. Whats the

Re: slave to master

Am Freitag, 29. April 2016, 14:49:57 schrieb william drescher: > On 4/28/2016 5:20 PM, Thomas wrote: > > Hi, > > > > I have setup an master slave replication. > > This works fine. > > I have running an Apache webserver and some other programms accessing the > > master. > > Whats the standard

Re: slave to master

Am 29.04.2016 um 20:49 schrieb william drescher: On 4/28/2016 5:20 PM, Thomas wrote: Hi, I have setup an master slave replication. This works fine. I have running an Apache webserver and some other programms accessing the master. Whats the standard pocedure if master fail? I want to start

Re: slave to master

: "Mahmoud Alshinhab" <mahmoud.alshin...@gmail.com <mailto:mahmoud.alshin...@gmail.com> <mailto:mahmoud.alshin...@gmail.com <mailto:mahmoud.alshin...@gmail.com>>>

Re: slave to master

b >> AWS Cloud Support Engineer >> Fedora Ambassador >> Wiki : https://fedoraproject.org/wiki/User:Tuxawy >> mahmoud.alshin...@gmail.com <mailto:mahmoud.alshin...@gmail.com> >> tux...@fedoraproject.org <mailto:tux...@fedoraproject.org> >> >

Re: slave to master

On 4/28/2016 5:20 PM, Thomas wrote: Hi, I have setup an master slave replication. This works fine. I have running an Apache webserver and some other programms accessing the master. Whats the standard pocedure if master fail? I want to start up the programms on the slave by hand and then they

Re: slave to master

thelounge.net>> wrote: Am 29.04.2016 um 15:07 schrieb Johan De Meersman: From: "Mahmoud Alshinhab" <mahmoud.alshin...@gmail.com <mailto:mahmoud.alshin...@gmail.com>> Subject: Re: slave to master

Re: slave to master

>> Fedora Ambassador >> Wiki : https://fedoraproject.org/wiki/User:Tuxawy >> mahmoud.alshin...@gmail.com >> tux...@fedoraproject.org >> >> On Fri, Apr 29, 2016 at 3:13 PM, Reindl Harald <h.rei...@thelounge.net> >> wrote: >> >>> >>

Re: slave to master

Am 29.04.2016 um 17:20 schrieb Mahmoud Alshinhab: Master/slave connection selection It’s the application that has to decide to use master or slave connection (the master connection is set by default). Switching the type of connection is done by using JDBC connection.setReadOnly(boolean

Re: slave to master

gt; wrote: > >> >> Am 29.04.2016 um 15:07 schrieb Johan De Meersman: >> >>> From: "Mahmoud Alshinhab" <mahmoud.alshin...@gmail.com> >>>> Subject: Re: slave to master >>>> >>> >>> I think you should have a look at M

Re: slave to master

:13 PM, Reindl Harald <h.rei...@thelounge.net> wrote: > > Am 29.04.2016 um 15:07 schrieb Johan De Meersman: > >> From: "Mahmoud Alshinhab" <mahmoud.alshin...@gmail.com> >>> Subject: Re: slave to master >>> >> >> I think you sho

Re: slave to master

Am 29.04.2016 um 15:07 schrieb Johan De Meersman: From: "Mahmoud Alshinhab" <mahmoud.alshin...@gmail.com> Subject: Re: slave to master I think you should have a look at MariaDB Connector[1]. It provides Load balancing and failover as Failover occurs when a connection to a

Re: slave to master

> From: "Mahmoud Alshinhab" <mahmoud.alshin...@gmail.com> > Subject: Re: slave to master > I think you should have a look at MariaDB Connector[1]. > It provides Load balancing and failover as Failover occurs when a connection > to > a primary database server fa

Re: slave to master

l Message - > > From: "Jason Mallory" <jason.mall...@iridium.com> > > Subject: RE: slave to master > > > > Master-master with load balancer would be best > > That's a bit brief, isn't it? :-) > > It's more than worth pointing out

Re: slave to master

- Original Message - > From: "Jason Mallory" <jason.mall...@iridium.com> > Subject: RE: slave to master > > Master-master with load balancer would be best That's a bit brief, isn't it? :-) It's more than worth pointing out that your loadbalancer should no

RE: slave to master

Master-master with load balancer would be best Jason Mallory, MySQL/SQL Server DBA p: +1.480.752.1198 | m: +1.480.823.7771 | f: +1. 480.752.1105  |  www.iridium.com The information contained in this email is strictly

Re: utf8 options under Mysql

Hi, On 22/04/2016 04:50, Martin Mueller wrote: MySQL has a bewildering variety of unicode collation choices. Most of them are language specific, but what is the difference between "utf8-general-ci", "utf8-unicode-ci", and "utf8-unicode-520-ci." Do they differ in the range of characters they

Re: Lost Connection Upon Loading Dump

On 4/21/2016 10:51, Stephen R Guglielmo wrote: Hello, I have a empty db that I'm trying to load a .sql file (created via mysqldump) into. The dump has 791611 lines and is 807 MB. Loading the dump is consistently failing at line 1763. Line 1763 is an INSERT statement. The line is 95610

Re: parallel installations of mysql

On 4/20/2016 2:04 PM, Martin Mueller wrote: I am running MySQL 5.6.22 on an iMac as a desktop database. I would like to install 5.7.12. Can I install it as a parallel and independent instance? And if so, are there special problems to watch out for? Why would I want to do this? Well, I

Re: parallel installations of mysql

That works nicely, you just need to make sure that you set up the second instance on a different port, with different data and log directories etc. Do you expect many issues from the upgrade? In most cases, an in-place upgrade should work the same or better than the old version :-) -

Re: threads in cleaning up mode

Can it be a consequence of slow disk also? Best Regards, Geetanjali Mehra Senior Database Administrator On Tue, Apr 5, 2016 at 10:50 AM, geetanjali mehra < mailtogeetanj...@gmail.com> wrote: > Thanks to everyone for response. Any other views from any one is always > welcome. > > Best

Re: threads in cleaning up mode

Thanks to everyone for response. Any other views from any one is always welcome. Best Regards, Geetanjali Mehra Senior Database Administrator On Mon, Apr 4, 2016 at 7:51 PM, shawn l.green wrote: > > > On 4/2/2016 10:36 AM, geetanjali mehra wrote: > >> Hi to all, >>

Re: threads in cleaning up mode

On 4/2/2016 10:36 AM, geetanjali mehra wrote: Hi to all, For many days, I am struggling with the problem of increasing history list length on mysql 5.6.29. Application that this server is running IOT based. Also, this server has so many threads running in sleeping mode. SHOW ENGINE INNODB

Re: threads in cleaning up mode

Hi, It sounds like a bad case of transactions handling by the application. If you have transactions/statements open for very long time, the list which contains the unflushed changes, grows. These unflushed changes will slow down the purge and in extreme cases, will also affect the DMLs. So,

Re: need help from the list admin

- Am 1. Apr 2016 um 21:56 schrieb shawn l.green shawn.l.gr...@oracle.com: > Correct. MyISAM is not a transactional storage engine. It has no concept > of COMMIT or ROLLBACK. Changes to it are controlled by a full table lock > and as soon as the change is complete, the table is unlocked and

Re: need help from the list admin

- Am 1. Apr 2016 um 17:45 schrieb shawn l.green shawn.l.gr...@oracle.com: >> Is the mix of MyISAM and InnoDB a problem with Row-Based-Logging or >> with Statement-Based-Logging or with both ? >> >> > > Both. > > >> >> I don't understand the example: >> Does "begin transaction" and

Re: need help from the list admin

Am 01.04.2016 um 21:09 schrieb Lentes, Bernd: - Am 1. Apr 2016 um 17:45 schrieb shawn l.green shawn.l.gr...@oracle.com: You said, "This is done on the master, written in the log and then replicated to the slave, " The INSERT would not appear in the Binary log until after session 1

Re: need help from the list admin

Sorry for pm ! - Am 1. Apr 2016 um 17:45 schrieb shawn l.green shawn.l.gr...@oracle.com: >>> You would be better served by first converting your MyISAM tables to >>> InnoDB to stop mixing storage engine behaviors (transactional and >>> non-transactional) within the scope of a single

Re: need help from the list admin

- Am 1. Apr 2016 um 17:52 schrieb shawn l.green shawn.l.gr...@oracle.com: >> What is true ? when the transaction started or when the first read is >> performed ? > Until you need to establish a snapshot of the data, then you don't need > a snapshot position. > > The transaction

Re: need help from the list admin

On 4/1/2016 10:08 AM, Lentes, Bernd wrote: - On Apr 1, 2016, at 3:12 PM, Bernd Lentes bernd.len...@helmholtz-muenchen.de wrote: Btw: i read about isolation levels. REPEATABLE READ is the default for InnoDB. http://dev.mysql.com/doc/refman/5.5/en/glossary.html#glos_repeatable_read says:

Re: need help from the list admin

On 4/1/2016 9:12 AM, Lentes, Bernd wrote: - On Mar 25, 2016, at 9:54 PM, shawn l.green shawn.l.gr...@oracle.com wrote: "Unsafe" in that sense replies to the fact that certain commands can have a different effect when processed from the Binary Log than they did when they were executed

Re: need help from the list admin

- On Apr 1, 2016, at 3:12 PM, Bernd Lentes bernd.len...@helmholtz-muenchen.de wrote: Btw: i read about isolation levels. REPEATABLE READ is the default for InnoDB. http://dev.mysql.com/doc/refman/5.5/en/glossary.html#glos_repeatable_read says: "...so that all queries within a transaction

RE: need help from the list admin

- On Mar 25, 2016, at 9:54 PM, shawn l.green shawn.l.gr...@oracle.com wrote: > "Unsafe" in that sense replies to the fact that certain commands can > have a different effect when processed from the Binary Log than they did > when they were executed originally on the system that wrote the

Re: need help from the list admin

On 3/30/2016 1:26 PM, Lentes, Bernd wrote: - On Mar 30, 2016, at 7:04 PM, Reindl Harald h.rei...@thelounge.net wrote: So i should use the default (autocommit=1)? no, you should what is appropriate for your application if you don't care about inserts/updates triggered by let say a

Re: need help from the list admin

Am 30.03.2016 um 19:26 schrieb Lentes, Bernd: - On Mar 30, 2016, at 7:04 PM, Reindl Harald h.rei...@thelounge.net wrote: So i should use the default (autocommit=1)? no, you should what is appropriate for your application if you don't care about inserts/updates triggered by let say a

RE: need help from the list admin

- On Mar 30, 2016, at 7:04 PM, Reindl Harald h.rei...@thelounge.net wrote: >> So i should use the default (autocommit=1)? > > no, you should what is appropriate for your application > > if you don't care about inserts/updates triggered by let say a > webrequest are half written due a crash

Re: need help from the list admin

Am 30.03.2016 um 18:56 schrieb Lentes, Bernd: - On Mar 28, 2016, at 9:53 PM, shawn l.green shawn.l.gr...@oracle.com wrote: I read that the converting is not difficult. But has the code of our webapp to be changed ? It's written in php and perl. What i understand is that

Re: need help from the list admin

- On Mar 28, 2016, at 9:53 PM, shawn l.green shawn.l.gr...@oracle.com wrote: >> >> I read that the converting is not difficult. But has the code of our webapp >> to >> be changed ? It's written in php and perl. >> What i understand is that inserts/updates/deletions in InnoDB tables have to

Re: need help from the list admin

Am 28.03.2016 um 21:36 schrieb Lentes, Bernd: - On Mar 27, 2016, at 2:49 PM, Reindl Harald h.rei...@thelounge.net wrote: Am 27.03.2016 um 14:34 schrieb Lentes, Bernd: You would be better served by first converting your MyISAM tables to InnoDB to stop mixing storage engine behaviors

Re: need help from the list admin

Hello Bernd, On 3/28/2016 3:36 PM, Lentes, Bernd wrote: - On Mar 27, 2016, at 2:49 PM, Reindl Harald h.rei...@thelounge.net wrote: Am 27.03.2016 um 14:34 schrieb Lentes, Bernd: You would be better served by first converting your MyISAM tables to InnoDB to stop mixing storage engine

Re: need help from the list admin

- On Mar 27, 2016, at 2:49 PM, Reindl Harald h.rei...@thelounge.net wrote: > Am 27.03.2016 um 14:34 schrieb Lentes, Bernd: >>> You would be better served by first converting your MyISAM tables to >>> InnoDB to stop mixing storage engine behaviors (transactional and >>> non-transactional)

Re: need help from the list admin

Am 27.03.2016 um 14:34 schrieb Lentes, Bernd: You would be better served by first converting your MyISAM tables to InnoDB to stop mixing storage engine behaviors (transactional and non-transactional) within the scope of a single transaction. But if you cannot convert them, using MIXED will be

Re: need help from the list admin

- Am 25. Mrz 2016 um 21:54 schrieb shawn l.green shawn.l.gr...@oracle.com: > Hello Bernd, > > Sorry for the delay, I wanted to make sure I had enough time to address > all of your points. >> He proposed to have two hosts, and on each is running a MySQL instance >> as master AND slave.

Re: mysql query for current date accounting returns NULL

On 3/26/2016 4:36 PM, shawn l.green wrote: On 3/25/2016 6:39 AM, JAHANZAIB SYED wrote: I have Freeradius 2.x with MySQL 5.5 in Ubuntu. I want to query user quota for current date. I am using following code SELECT (SUM(acctinputoctets)+SUM(acctoutputoctets)) AS Total FROM radacct where

Re: mysql query for current date accounting returns NULL

On 3/25/2016 6:39 AM, JAHANZAIB SYED wrote: I have Freeradius 2.x with MySQL 5.5 in Ubuntu. I want to query user quota for current date. I am using following code SELECT (SUM(acctinputoctets)+SUM(acctoutputoctets)) AS Total FROM radacct where (acctstarttime between

Re: need help from the list admin

Hello Bernd, Sorry for the delay, I wanted to make sure I had enough time to address all of your points. On 3/22/2016 7:07 AM, william drescher wrote: sent for Bernd, and to see if it works from another sender -- Lentes, Bernd wrote: Hi, i know

Re: mysql query for current date accounting returns NULL

2016/03/25 06:39 ... JAHANZAIB SYED: I want to query user quota for current date. I am using following code SELECT SUM(acctinputoctets)+SUM(acctoutputoctets) AS Total FROM radacct where (acctstarttime between DATE_FORMAT(NOW(),'%Y-%m-%d') AND NOW() AND acctstoptime between DATE_FORMAT(NOW()

Re: need help from the list admin

- On Mar 23, 2016, at 11:11 AM, william drescher will...@techservsys.com wrote: >> >> Hi William, >> >> thanks for the try. Good idea ! >> Did you change anything ? >> >> >> Bernd > > Yes, in the original document there were some characters that > were put on the screen as asian

Re: need help from the list admin

On 3/22/2016 7:49 AM, Lentes, Bernd wrote: - On Mar 22, 2016, at 12:07 PM, william drescher will...@techservsys.com wrote: sent for Bernd, and to see if it works from another sender -- Lentes, Bernd wrote: Hi, i know that there is a list

Re: Workbench MySQL Enterprise Backup Error

The beauty of running enterprise versions is that you have support from Oracle. I would gently point you in their direction if not to get what you paid for but also because most of us in this list are unequipped to help you because we don't use the software you have problems with. Good luck On 22

Re: need help from the list admin

- On Mar 22, 2016, at 12:07 PM, william drescher will...@techservsys.com wrote: > sent for Bernd, and to see if it works from another sender > -- > Lentes, Bernd wrote: > Hi, > > i know that there is a list dedicated to replication, but when >

Re: need help from the list admin

sent for Bernd, and to see if it works from another sender -- Lentes, Bernd wrote: Hi, i know that there is a list dedicated to replication, but when you have a look in the archive it's nearly complete empty. Really not busy. So i hope it's ok if i

Re: does anyone else have problems sending mails to this list ?

Am 22.03.2016 um 02:05 schrieb Jan Steinman: please refrain from answering when you have no clue how DNS blacklists are working and what about others are talking Well, excuse me! Someone put on their bossy pants this morning! A simple “That’s not what’s going on here” would have been

Re: does anyone else have problems sending mails to this list ?

> please refrain from answering when you have no clue how DNS blacklists are > working and what about others are talking Well, excuse me! Someone put on their bossy pants this morning! A simple “That’s not what’s going on here” would have been much nicer. J -- MySQL General Mailing List

Re: Conditional ODER BY Clause HELP

2016/03/18 12:54 ... Don Wieland: Trying to get the correct syntax on this: ORDER BY CASE WHEN tr.Placed = "X" THEN r.Division ASC, FIELD(tr.Place,"1","2","3","4","5","6","7","8","R","WD","Exc","E","S”), tr.Score DESC WHEN tr.Placed != "X" THEN tr.ride_time ASC END How does

Re: need help from the list admin

- On Mar 19, 2016, at 3:28 PM, Reindl Harald h.rei...@thelounge.net wrote: > Am 19.03.2016 um 15:23 schrieb Reindl Harald: >> >> >> Am 19.03.2016 um 15:17 schrieb Lentes, Bernd: >>> one further question: >>> if some of my e-mails get through (like this one) and others don't, it >>> does not

Re: does anyone else have problems sending mails to this list ?

Am 20.03.2016 um 20:22 schrieb Reindl Harald: Am 20.03.2016 um 20:16 schrieb Jan Steinman: From: Reindl Harald Date: 17 March 2016 at 06:27:22 PDT Am 17.03.2016 um 14:06 schrieb Lentes, Bernd: i still can't send my question to the ML. Our outgoing Mailer has a new

Re: does anyone else have problems sending mails to this list ?

Am 20.03.2016 um 20:16 schrieb Jan Steinman: From: Reindl Harald Date: 17 March 2016 at 06:27:22 PDT Am 17.03.2016 um 14:06 schrieb Lentes, Bernd: i still can't send my question to the ML. Our outgoing Mailer has a new IP which is not listed

Re: does anyone else have problems sending mails to this list ?

> From: Reindl Harald > Date: 17 March 2016 at 06:27:22 PDT > > Am 17.03.2016 um 14:06 schrieb Lentes, Bernd: >> i still can't send my question to the ML. Our outgoing Mailer has a new IP >> which is not listed >>

Re: does mysql alert about all the duplicates?

Maybe this post will help you with your user/config question. http://stackoverflow.com/questions/548541/insert-ignore-vs-insert-on-duplicate-key-update > On Mar 16, 2016, at 7:46 AM, Reindl Harald

Re: need help from the list admin

Am 18.03.2016 um 14:56 schrieb Chris Knipe: Blah blah blah... Delivery to the following recipient failed permanently: mysql@lists.mysql.com Technical details of permanent failure: Your message was rejected by the server for the recipient domain lists.mysql.com by lists-mx.mysql.com.

Re: need help from the list admin

On Fri, Mar 18, 2016 at 3:43 PM, Lentes, Bernd < bernd.len...@helmholtz-muenchen.de> wrote: > i need your help. I'm trying to write an e-Mail to the list for already > one week. I always get it back because it's classified as spam. > Ditto. I've pretty much given up on this list...

Re: need help from the list admin

Am 19.03.2016 um 15:23 schrieb Reindl Harald: Am 19.03.2016 um 15:17 schrieb Lentes, Bernd: one further question: if some of my e-mails get through (like this one) and others don't, it does not depend on theh reputation of our domain or mailserver ? Right ? So the reason has to be that

Re: need help from the list admin

Am 19.03.2016 um 15:17 schrieb Lentes, Bernd: one further question: if some of my e-mails get through (like this one) and others don't, it does not depend on theh reputation of our domain or mailserver ? Right ? So the reason has to be that particular e-Mail? both a spamfilter is typically

Re: need help from the list admin

Am 19.03.2016 um 15:08 schrieb Lentes, Bernd: Ok. I tried again: pc53200:~ # nslookup 20.103.107.146.score.senderscore.com. Server: 146.107.8.88 Address:146.107.8.88#53 Non-authoritative answer: Name: 20.103.107.146.score.senderscore.com Address: 127.0.4.62 My result is

Re: need help from the list admin

Hi, one further question: if some of my e-mails get through (like this one) and others don't, it does not depend on theh reputation of our domain or mailserver ? Right ? So the reason has to be that particular e-Mail ? Bernd Helmholtz Zentrum Muenchen Deutsches Forschungszentrum fuer

Re: need help from the list admin

- Am 18. Mrz 2016 um 15:34 schrieb Reindl Harald h.rei...@thelounge.net: > Am 18.03.2016 um 15:25 schrieb Lentes, Bernd: >> >> - Am 18. Mrz 2016 um 14:52 schrieb Johan De Meersman vegiv...@tuxera.be: >> > > as i already told you offlist > senderscore.com LISTED 127.0.4.67 > > this

Re: need help from the list admin

. If the mailserver classifies you as spam, that's usually caused by something on your side :-) - Original Message - From: "Chris Knipe" <sav...@savage.za.org> To: "Lentes, Bernd" <bernd.len...@helmholtz-muenchen.de> Cc: "MySql" <mysql@lists.mysql.com> S

Re: does anyone else have problems sending mails to this list ?

Hi, i still can't send my question to the ML. Our outgoing Mailer has a new IP which is not listed (http://mxtoolbox.com/SuperTool.aspx?action=blacklist%3a146.107.103.20=toolpage#), our domain is not listed

Re: does anyone else have problems sending mails to this list ?

Am 17.03.2016 um 14:06 schrieb Lentes, Bernd: i still can't send my question to the ML. Our outgoing Mailer has a new IP which is not listed (http://mxtoolbox.com/SuperTool.aspx?action=blacklist%3a146.107.103.20=toolpage#), our domain is not listed

Re: does mysql alert about all the duplicates?

thanks Rebecca, I'm looking at this examples and still wonder - how do I insert into my.table select * from my.othertable and allow all the updates? Both tables are schematically identical. Seems I cannot get the syntax around it. many thanks On 16/03/16 14:38, Rebecca Love wrote:

<    1   2   3   4   5   6   7   8   9   10   >