ent result.
Bernd
Helmholtz Zentrum Muenchen
Deutsches Forschungszentrum fuer Gesundheit und Umwelt (GmbH)
Ingolstaedter Landstr. 1
85764 Neuherberg
www.helmholtz-muenchen.de
Aufsichtsratsvorsitzende: MinDir'in Baerbel Brumme-Bothe
Geschaeftsfuehrer: Prof. Dr. Guenther Wess, Dr. Alfons En
on the slave that happened on the master.
>
>
In case of a rollback: is the INSERT in the MyISAM table also rollbacked ?
I think no.
Bernd
Helmholtz Zentrum Muenchen
Deutsches Forschungszentrum fuer Gesundheit und Umwelt (GmbH)
Ingolstaedter Landstr. 1
85764 Neuherberg
www.helmholtz-muenchen.de
Aufsichtsratsvorsitzende: MinDir'in Baerbel Brumme-Bothe
Geschaeftsfuehrer: Prof. Dr. Guenther Wess, Dr. Alfons Enhsen, Renate Schlusen
(komm.)
Registergericht: Amtsgericht Muenchen HRB 6466
USt-IdNr: DE 129521671
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
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
commits
if the transaction that rolled back contained statements that
> changed MyISAM tables, then the entire transaction (all of the work it
> did) needs to be written into the Binary Log and REDO log just to have
> the very last command be "ROLLBACK". What that will do is create
mbH)
Ingolstaedter Landstr. 1
85764 Neuherberg
www.helmholtz-muenchen.de
Aufsichtsratsvorsitzende: MinDir'in Baerbel Brumme-Bothe
Geschaeftsfuehrer: Prof. Dr. Guenther Wess, Dr. Alfons Enhsen, Renate Schlusen
(komm.)
Registergericht: Amtsgericht Muenchen HRB 6466
USt-IdNr: DE 1
Services
Office: Blountville, TN
Become certified in MySQL! Visit https://www.mysql.com/certification/
for details.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
ve that happened on the master.
Thanks.
You're welcome
Bernd
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Integrated Cloud Applications & Platform Services
Office: Blountville, TN
Become certified in MySQL! Visit https://www.mysql.com/certification/
for details.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
rsitzende: MinDir'in Baerbel Brumme-Bothe
Geschaeftsfuehrer: Prof. Dr. Guenther Wess, Dr. Alfons Enhsen, Renate Schlusen
(komm.)
Registergericht: Amtsgericht Muenchen HRB 6466
USt-IdNr: DE 129521671
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
kind of self-protection needs to happen in your
> application logic.
>
> Only using one type of storage engine per transaction is the other way
> to avoid the problem.
Independent from the binlog_format ?
Does commit means "write now to the binlog" ?
Thanks.
Bernd
Helmholtz Zentrum Muenchen
Deutsches Forschungszentrum fuer Gesundheit und Umwelt (GmbH)
Ingolstaedter Landstr. 1
85764 Neuherberg
www.helmholtz-muenchen.de
Aufsichtsratsvorsitzende: MinDir'in Baerbel Brumme-Bothe
Geschaeftsfuehrer: Prof. Dr. Guenther Wess, Dr. Alfons Enhsen, Renate Schlusen
(komm.)
Registergericht: Amtsgericht Muenchen HRB 6466
USt-IdNr: DE 129521671
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
d in MySQL! Visit https://www.mysql.com/certification/
for details.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
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
w
uenther Wess, Dr. Alfons Enhsen, Renate Schlusen
(komm.)
Registergericht: Amtsgericht Muenchen HRB 6466
USt-IdNr: DE 129521671
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
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 inserts/updates/dele
MinDir'in Baerbel Brumme-Bothe
Geschaeftsfuehrer: Prof. Dr. Guenther Wess, Dr. Alfons Enhsen, Renate Schlusen
(komm.)
Registergericht: Amtsgericht Muenchen HRB 6466
USt-IdNr: DE 129521671
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
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 (tran
START TRANSACTION and
COMMIT.
Bernd
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Integrated Cloud Applications & Platform Services
Office: Blountville, TN
Become certified in MySQL! Visit https://www.mysql.com/certification/
for details.
--
M
helmholtz-muenchen.de
Aufsichtsratsvorsitzende: MinDir'in Baerbel Brumme-Bothe
Geschaeftsfuehrer: Prof. Dr. Guenther Wess, Dr. Alfons Enhsen, Renate Schlusen
(komm.)
Registergericht: Amtsgericht Muenchen HRB 6466
USt-IdNr: DE 129521671
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
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 a
problems when using RBL ?
>>
>>
>
> Because the commands ("events" in the terminology used to describe the
> Binary Log) are not recorded until their transaction completes it is
> possible for other earlier-finishing transactions looking at
> non-transactional tables to make changes that are out of sequence.
>
> It's possible for the two storage engines to co-exist but you need to be
> careful or you will create the database equivalent to the "grandfather
> paradox". This kind of self-protection needs to happen in your
> application logic.
>
> Only using one type of storage engine per transaction is the other way
> to avoid the problem.
I will try that.
Hi Shawn,
thanks for this very profound and detailed answer. Great !
Bernd
Helmholtz Zentrum Muenchen
Deutsches Forschungszentrum fuer Gesundheit und Umwelt (GmbH)
Ingolstaedter Landstr. 1
85764 Neuherberg
www.helmholtz-muenchen.de
Aufsichtsratsvorsitzende: MinDir'in Baerbel Brumme-Bothe
Geschaeftsfuehrer: Prof. Dr. Guenther Wess, Dr. Alfons Enhsen, Renate Schlusen
(komm.)
Registergericht: Amtsgericht Muenchen HRB 6466
USt-IdNr: DE 129521671
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
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 ask here.
we have a web app which runs a MySQL DB and dynamic webpages with perl
and apache httpd. Webpages serve reading and writing i
. Guenther Wess, Dr. Alfons Enhsen, Renate Schlusen
(komm.)
Registergericht: Amtsgericht Muenchen HRB 6466
USt-IdNr: DE 129521671
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
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
- 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 rep
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'
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 mu
> 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 Mailin
ase of RBLs?
>> https://en.wikipedia.org/wiki/Reverse_DNS_lookup
>
> and that your domain even don't provide a "~all" SPF policy if you can't
> or don't want a stricht "-all" makes things not better, typically a
> SPF_PASS gives benefits in
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 IP which is not listed
(
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
(http://mxtoolbox.com/SuperTool.aspx?action=black
t i still get it back:
>
> at least not terrible good
> senderscore.com LISTED127.0.4.63
Uhm… the 127 Class A network is the “super local network,” used for processes
on the same physical machine.
You need to look at other Received: headers than the ones that start with 127.
Jan
Dear list admin,
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.
The mail is formatted as plain-text, include neither links nor attachments. I
don't understand why it's classified as spam
from' identity (mechanism
'include:_spf.google.com' matched)) receiver=amysql-list-wsv01.oracle.com;
identity=mailfrom; envelope-from="ckn...@savage.za.org";
helo=mail-qg0-f51.google.com; client-ip=209.85.192.51
signature.asc
Description: OpenPGP digital signature
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...
a
SPF_PASS gives benefits in spamfilter scorings
Received-SPF: none (helmholtz-muenchen.de: No applicable sender policy
available) receiver=amysql-list-wsv01.oracle.com; identity=mailfrom;
envelope-from="bernd.len...@helmholtz-muenchen.de";
helo=mtaextp1.scidom.de; client-ip=146.107
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
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 127
t-IdNr: DE 129521671
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
ther Wess, Dr. Alfons Enhsen, Renate Schlusen
(komm.)
Registergericht: Amtsgericht Muenchen HRB 6466
USt-IdNr: DE 129521671
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
f the mailserver classifies you as spam, that's
usually caused by something on your side :-)
- Original Message -
From: "Chris Knipe"
To: "Lentes, Bernd"
Cc: "MySql"
Sent: Friday, 18 March, 2016 14:46:26
Subject: Re: need help from the list admin
Ditto.
e: +49 (0)89 3187 1241
fax: +49 (0)89 3187 2294
Wer Visionen hat soll zum Hausarzt gehen
Helmut Schmidt
- Am 9. Mrz 2016 um 12:56 schrieb Reindl Harald h.rei...@thelounge.net:
> Am 09.03.2016 um 11:44 schrieb Lentes, Bernd:
>> i tried yesterday several times to send an e-Mail to
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&run=toolpage#),
our domain is not listed
(http://mxtoolbox.com/SuperTool.aspx?act
;
>>> - Original Message -
>>>
>>>> From: "Chris Knipe"
>>>> To: "Lentes, Bernd"
>>>> Cc: "MySql"
>>>> Sent: Friday, 18 March, 2016 14:46:26
>>>> Subject: Re: need help from the list adm
u as spam, that's
> usually caused by something on your side :-)
>
> - Original Message -
>> From: "Chris Knipe"
>> To: "Lentes, Bernd"
>> Cc: "MySql"
>> Sent: Friday, 18 March, 2016 14:46:26
>> Subj
> > To: "Lentes, Bernd"
> > Cc: "MySql"
> > Sent: Friday, 18 March, 2016 14:46:26
> > Subject: Re: need help from the list admin
>
> > Ditto. I've pretty much given up on this list...
>
> --
> Unhappiness is discouraged and will be corrected with kitten pictures.
>
--
Regards,
Chris Knipe
Am 09.03.2016 um 11:44 schrieb Lentes, Bernd:
i tried yesterday several times to send an e-Mail to this list. E-Mail is
formatted as plain-text, has no links included and no attachment but is
declined as spam. This is what is bounced:
: host lists-mx.mysql.com[137.254.60.71] said: 552 spam
o remove the
spammers from their networks, legitimate customers get penalized.
Best regards,
Olivier
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Hi,
i tried yesterday several times to send an e-Mail to this list. E-Mail is
formatted as plain-text, has no links included and no attachment but is
declined as spam. This is what is bounced:
: host lists-mx.mysql.com[137.254.60.71] said: 552 spam
score exceeded threshold (#5.6.1) (in
why do you think we could do that for you and what do you think is that
link in every mail for? YES i send this to the list hopefully to save a
few of this "meh i can't handle my mail".
To unsubscribe:http://lists.mysql.com/mysql
Am 22.07.2015 um 18:08 schrieb Charle
Dear Sirs,
I'd like to unsubscribe my subscription to this mailing list.
Thank you so much.
Regards
Andrea Fanni
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
So I've done some more digging on this.
1. Upgraded to MySQL 5.5.37
2. Made sure we didn't have any old/long running transactions--nothing
more than a few seconds.
3. Did a dump/reload in to a new DB and started with an empty history
list. A few days later, we're ba
Hi Brad,
> -Original Message-
> From: Brad Heller [mailto:b...@cloudability.com]
> Sent: Sunday, 7 September 2014 03:07
> To: MySQL General List
> Subject: MySQL 5.5.33 History list not purging?
>
> For some reason, the history list isn't purging on one of my
w.twitter.com/bradhe> | @cloudability
<http://www.twitter.com/cloudability>
We're hiring! https://cloudability.com/jobs
<http://www.cloudability.com/jobs>
On Sat, Sep 6, 2014 at 10:12 AM, Reindl Harald
wrote:
>
> Am 06.09.2014 um 19:07 schrieb Brad Heller:
> > Fo
Am 06.09.2014 um 19:07 schrieb Brad Heller:
> For some reason, the history list isn't purging on one of my masters. This
> is causing all kinds of weird issues/behavior with reads
so why do you not just try to update first?
5.5.39 is recent and contains *a lot* of bufixes
look at the
For some reason, the history list isn't purging on one of my masters. This
is causing all kinds of weird issues/behavior with reads. Here's the last 8
or so hours of history list length:
http://i.imgur.com/Q4DEeVi.png
Here are my innodb%purge% settings.
mysql> show variables where
Or
SELECT ... \G
(replace ';' with '\G')
> -Original Message-
> From: h...@tbbs.net [mailto:h...@tbbs.net]
> Sent: Wednesday, April 24, 2013 9:55 AM
> To: mysql list
> Subject: Re: how to list record in column (instead of a row)
>
> &
you can do:
select * from table\G
2013/4/24
> >>>> 2013/04/24 09:06 -0700, Rajeev Prasad >>>>
> this table has many columns and only 1 record. select * from table;
> generates an unreadable list. how can i list the record as in two columns?
> (column name
>>>> 2013/04/24 09:06 -0700, Rajeev Prasad >>>>
this table has many columns and only 1 record. select * from table; generates
an unreadable list. how can i list the record as in two columns? (column name
and its value)? i looked at UNPIVOT, but could not get it to work.
this table has many columns and only 1 record.
select * from table;
generates an unreadable list.
how can i list the record as in two columns? (column name and its value)?
i looked at UNPIVOT, but could not get it to work.
SQL> select * from table UNPIVOTE INCLUDE NU
ht a
table like that, and paste it into Excel. That darn Microsoft -- they think
of everything! :) Thanks for the tip.
-Original Message-
From: Nuno Tavares [mailto:nuno.tava...@dri.pt]
Sent: Wednesday, October 03, 2012 3:10 PM
To: mysql@lists.mysql.com
Subject: Re: need list of country I
ave
Thanks for the tip.
-Original Message-
From: Nuno Tavares [mailto:nuno.tava...@dri.pt]
Sent: Wednesday, October 03, 2012 3:10 PM
To: mysql@lists.mysql.com
Subject: Re: need list of country ISO code to demonyms
I don't have it, sorry.
But it took me 10 seconds to copy & pas
Wednesday, October 03, 2012 3:10 PM
> To: mysql@lists.mysql.com
> Subject: Re: need list of country ISO code to demonyms
>
> I don't have it, sorry.
>
> But it took me 10 seconds to copy & paste it to an Excel, so I could
> save it as CSV and import it directly to M
curate,
and ripping that out of the HTML page to parse seems painful too.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Anyone have a SQL dump or other programmatically useable map of country ISO
codes to demonyms?
http://www.geography-site.co.uk/pages/countries/demonyms.html
I can parse the strings I suppose there, but that's not quite as accurate,
and ripping that out of the HTML page to parse seems painful too.
On Fri, 2012-05-18 at 03:40 +0200, Reindl Harald wrote:
> Am 18.05.2012 02:51, schrieb Noel Butler:
> > List is broken, in many ways.
> >
> > Amongst many of its failures, the two current biggest is:
> >
> > 1/ This lists bounce messages are clueless they do
Am 18.05.2012 02:51, schrieb Noel Butler:
> List is broken, in many ways.
>
> Amongst many of its failures, the two current biggest is:
>
> 1/ This lists bounce messages are clueless they do not include the
> reject reason
which bounce-messages are you meaning?
may it be y
List is broken, in many ways.
Amongst many of its failures, the two current biggest is:
1/ This lists bounce messages are clueless they do not include the
reject reason
2/ mysql-owner address STILL points to a sun address which of course is
rejected as they no longer host this list.
*sigh*
- Original Message -
> From: "Reindl Harald"
>
> why does this idiotic list-server not add
> Precedence-Headers to supress autoreplies?
How many autoreplies did you get to that? :-D
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwe
d Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
7;re each going to have a number of descendants, where I
don't know the number of descendant rows, or the number of actual
descendants.
But either way, once I get the descendant list, I still need some way
of linking the childID of the descendant to the linked ID of the
statusTBL so I can get
has a
single descendant. For my app, I'm going to have a number of top level
items, and they're each going to have a number of descendants, where I
don't know the number of descendant rows, or the number of actual
descendants.
But either way, once I get the descendant list, I still need
On 1/16/2012 12:53 PM, bruce wrote:
On Mon, Jan 16, 2012 at 1:52 PM, bruce wrote:
Hey Authur.
Should have been more clear. I've looked over a number of sites. And
with the exception of the the articles that talk about using the
"Nested List" approach, nowhere did I find data
On Mon, Jan 16, 2012 at 1:52 PM, bruce wrote:
> Hey Authur.
>
> Should have been more clear. I've looked over a number of sites. And
> with the exception of the the articles that talk about using the
> "Nested List" approach, nowhere did I find data on how to get
See the piece on trees at www.artfulsoftware.com. It goes into several
variations of how to handle hierarchies.
HTH,
--
Arthur
Cell: 647.710.1314
Prediction is difficult, especially of the future.
-- Neils Bohr
l the levels...
I've looked at various articles, but not sure which is the best
approach to this kind of issue.
A complete run is determined by: when all children of the top
level/root node != '0'
Is this a self join,left join situation?
A sample query/pointers would be helpful
Is this a production setup.
If not, take complete dump of the all databases.
Drop the xYZ database, see if you can see all the objects under XYZ.
Since the xYZ database is created, its obvious, that names are case
sensitive, and it show not show object from XYZ, when u under xYZ.
Can you please
There is one database name 'XYZ' on linux system, some one has mistakenly
created new
database name with 'xYZ', database is created when I use 'xYZ' database, there
are no
tables with SHOW TABLES, but when i run SHOW PROCEDURE STATUS it show
procedures from
'XYZ' database.
My concern is that if
>>>> 2011/06/05 23:30 +0200, Reindl Harald >>>>
BTW
WHY is everybody ans[w]ering to the list AND the author of the last post?
<<<<<<<<
Because it is a damn' nuisance to enter "answer all" and therupon move the
list-email-address
fying those expressions)!
Yours,
Daniel
--
http://www.pro-vegan.info/
--
Done: Arc-Bar-Cav-Kni-Ran-Rog-Sam-Tou-Val-Wiz
To go: Hea-Mon-Pri
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
is construct
IF(b.`Name` IS NULL, '', b.`Name`)
there is a special function IFNULL:
IFNULL(b.`Name`, '')
It has the same special type-treatment that IF has.
I quite often use it.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
solution before... But 'inlining' my function this way seems to fix the
problem also in my real application.
Thanks a lot!
Yours,
Daniel
--
http://www.pro-vegan.info/
--
Done: Arc-Bar-Cav-Kni-Ran-Rog-Sam-Tou-Val-Wiz
To go: Hea-Mon-Pri
--
MySQL General Mailing List
For list archiv
11 2:03 PM
To: Larry McGhaw
Cc: Daevid Vincent; mysql@lists.mysql.com
Subject: Re: WHERE does not work on calculated view field - Found word(s) list
error in the Text body
On 04/22/11 22:41, Larry McGhaw wrote:
> It does appear to be some type of bug to me.
Hm... do you have an idea how to wo
essage-
From: Daniel Kraft [mailto:d...@domob.eu]
Sent: Friday, April 22, 2011 1:05 PM
To: Daevid Vincent
Cc: mysql@lists.mysql.com
Subject: Re: WHERE does not work on calculated view field - Found word(s) list
error in the Text body
Hi,
thanks for the fast reply!
On 04/22/11 21:39, Daevid V
On 22.04.2011 22:41, Larry McGhaw wrote:
It does appear to be some type of bug to me.
I agree. I was thrown by Daniels "first and third" comment, which I
guess should read "second and third"
I reproduced the behavior in 5.1.53-community on Windows.
/ Carsten
--
MySQL
mysql@lists.mysql.com
Subject: Re: WHERE does not work on calculated view field - Found word(s) list
error in the Text body
Hi,
thanks for the fast reply!
On 04/22/11 21:39, Daevid Vincent wrote:
>> DROP DATABASE `test`;
>> CREATE DATABASE `test`;
>> USE `test`;
>>
>> CREATE
ish) autoreply-spammer
> from the list nbecause the only thing i understand is some
> price in € and that our spm-firewall is tagging it
>
> Original-Nachricht
> Betreff:[SPAM] Re: Re: Can't connect to MySQL server on '127.0.0.1'
> (111)
>
Can anybody remove this (i think spanish) autoreply-spammer
from the list nbecause the only thing i understand is some
price in € and that our spm-firewall is tagging it
Original-Nachricht
Betreff:[SPAM] Re: Re: Can't connect to MySQL server on '127.0.0.1
Hi
Please unsubscribe my ID from the list
Best
Pratyaksh Nidhi Sharma
Hi
Please unsubscribe my ID from the list
Best
Swagat Lenka
This message is for the designated recipient only and may contain privileged,
proprietary, or otherwise private information. If you have received it in
error, please notify the sender immediately and delete the original. Any
On Tue, Dec 14, 2010 at 12:52, Patrice Olivier-Wilson wrote:
> On 12/14/10 12:51 PM, Patrice Olivier-Wilson wrote:
>>
>> I have a question that this list solved a year ago, and I can't remember
>> what the solution was. Does this list have an archive?
>>
>>
On 12/14/10 12:51 PM, Patrice Olivier-Wilson wrote:
I have a question that this list solved a year ago, and I can't remember
what the solution was. Does this list have an archive?
(Sorry if it is on one of the links to the list, but I don't have any on
hand at the moment.)
see
I have a question that this list solved a year ago, and I can't remember
what the solution was. Does this list have an archive?
(Sorry if it is on one of the links to the list, but I don't have any on
hand at the moment.)
--
Patrice Olivier-Wilson
http://biz-comm.com
--
MySQL Gener
te de personas distintas de los destinatarios del mismo está prohibido. Para
más detalles, por favor dirigirse a
http://www.scotiabank.com/email_disclaimer/email_espanol.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?
each tid in
> my 'in' clause that is the max id for that tid.:
>
> tid:id -> 123:8 for instance.
>
> Maybe a group by or something?
>
--
Kévin Labécot
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
I have a simple table
mytable
id int
time_stamp tiemstamp
value int
tid int
I want to find the max id for each individual tid in my table.
if I did it one by one it would be:
select max(id) from mytable where tid = 12345;
but how can I do something more like:
select concat(tid,':',id) from my
On Mon, 6 Sep 2010 06:36:02 -0400 (EDT), "Robert P. J. Day"
wrote:
> no, i don't want to start a flame war, i just want some feedback on
> a current list of mysql "drawbacks" WRT postgresql.
>
> in the context of a fully open-source, java based ECM
no, i don't want to start a flame war, i just want some feedback on
a current list of mysql "drawbacks" WRT postgresql.
in the context of a fully open-source, java based ECM product, there
is a FAQ entry that summarizes why the developers would prefer their
users to use postgr
y... itchy
trigger finger.
- Original Message - From: "Gavin Towey"
To: "Tompkins Neil" ; "[MySQL]" >
Sent: Thursday, August 19, 2010 1:50 PM
Subject: RE: Fixture List generation using MySQL
That's almost a cartesean product; except you just w
a condition to prevent those
> rows from showing up:
>
> > select * from teams t1 JOIN teams t2 ON t1.id!=t2.id;
> +++
> | id | id |
> +++
> | 2 | 1 |
> | 3 | 1 |
> | 4 | 1 |
> | 1 | 2 |
> | 3 | 2 |
> | 4 | 2 |
> | 1 | 3 |
&g
quot; ; "[MySQL]"
Sent: Thursday, August 19, 2010 1:50 PM
Subject: RE: Fixture List generation using MySQL
That's almost a cartesean product; except you just want to eliminate results
where a team would be paired up with itself.
create table teams ( id serial );
Query OK, 0 rows
well as the logic is quite
simple.
Regards,
--
Burhan Khalid
Sent from my BlackBerry® smartphone from Wataniya Telecom
-Original Message-
From: Peter Brawley
Date: Thu, 19 Aug 2010 12:48:18
To:
Reply-To: peter.braw...@earthlink.net
Subject: Re: Fixture List generation using MySQL
>I
1 - 100 of 1057 matches
Mail list logo
