.
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 Sc
ave 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
hat 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 the
> same sequen
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
ices
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
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:ht
appen 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
/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
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
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
NSACTION 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.
--
MySQL Gener
oltz-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
;>
>
> 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 into the db
nther 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's ok if i
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
> 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
e 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 spamfilter scorings
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
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
ext but 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 w
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. Neither our domain
(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...
enefits 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.103.20
[harry@srv-
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
129521671
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
s 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
ent: 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...
Neither our outgoing mailserver
(http://mxtoolbox.com/SuperTool.aspx?action=blacklist%3a146.107.103.20=toolpage#)
nor our domain
(http://mxtoolbox.com/SuperTo
(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 this lis
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
e :-)
>>>
>>> - Original Message -
>>>
>>>> From: "Chris Knipe" <sav...@savage.za.org>
>>>> To: "Lentes, Bernd" <bernd.len...@helmholtz-muenchen.de>
>>>> Cc: "MySql" <mysql@lists.mysql.com&g
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.c
"Chris Knipe" <sav...@savage.za.org>
> > To: "Lentes, Bernd" <bernd.len...@helmholtz-muenchen.de>
> > Cc: "MySql" <mysql@lists.mysql.com>
> > Sent: Friday, 18 March, 2016 14:46:26
> > Subject: Re: need help from the list admin
>
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:
<mysql@lists.mysql.com>: host lists-mx.mys
o are not diligent enough to 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:
<mysql@lists.mysql.com>: host lists-mx.mysql.com[137.254.60.71] said: 552 spam
score ex
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 Charles Turner:
Dear Sirs
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 back up over 3mil
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 masters. This is
causing all kinds
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 Variable_name
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 changelogs
/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 h.rei...@thelounge.net
wrote:
Am 06.09.2014 um 19:07 schrieb Brad Heller:
For some reason, the history list
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)
2013/04/24 09:06 -0700, Rajeev Prasad
this table has
you can do:
select * from table\G
2013/4/24 h...@tbbs.net
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
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 NULLS
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.
SQL select * from table UNPIVOTE
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
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
, 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 MySQL. Further on, it'd be as
simples as JOIN by name
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 paste
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 ISO code
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*
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 you mean the stupid auto
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 not include the
reject reason
which
- Original Message -
From: Reindl Harald h.rei...@thelounge.net
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 kwezel
Hy die't
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
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
Thoughts/Thanks
--
MySQL General Mailing List
For list archives: http
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
On Mon, Jan 16, 2012 at 1:52 PM, bruce badoug...@gmail.com 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 a
complete list
On 1/16/2012 12:53 PM, bruce wrote:
On Mon, Jan 16, 2012 at 1:52 PM, brucebadoug...@gmail.com 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
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 some way
of linking
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 the status of the childID/app
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
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
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
-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
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 work around this bug then?
Yours
' 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 archives: http://lists.mysql.com/mysql
-
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 Vincent
@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 TABLE `mytable`
(`ID` SERIAL,
`Type
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 General Mailing List
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'
(111)
Datum: 2 Apr 2011 17:17
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'
(111)
Datum
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
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 General Mailing
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
On Tue, Dec 14, 2010 at 12:52, Patrice Olivier-Wilson b...@biz-comm.com 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?
(Sorry if it is on one
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?unsub
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
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
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 postgresql as opposed
On Mon, 6 Sep 2010 06:36:02 -0400 (EDT), Robert P. J. Day
rpj...@crashcourse.ca 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 product, there
is a FAQ entry
.
Regards,
Gavin Towey
-Original Message-
From: Tompkins Neil [mailto:neil.tompk...@googlemail.com]
Sent: Thursday, August 19, 2010 10:07 AM
To: [MySQL]
Subject: Re: Fixture List generation using MySQL
I'm looking at a routine / script to create the fixtures like
team 1 vs team 2
team
... itchy
trigger finger.
- Original Message - From: Gavin Towey gto...@ffn.com
To: Tompkins Neil neil.tompk...@googlemail.com; [MySQL] mysql@lists.mysql.com
Sent: Thursday, August 19, 2010 1:50 PM
Subject: RE: Fixture List generation using MySQL
That's almost a cartesean product
Hi,
I'm tasked with generating a list of fixtures from a table of teams, whereby
each team plays each other home and away. Does anyone have any experience
generating such information using MySQL ?
Thanks for any input.
Regards
Neil
I'm tasked with generating a list of fixtures from a table of teams, whereby
each team plays each other home and away. Does anyone have any experience
generating such information using MySQL ?
Basically ...
select a.id,b.id from tbl a join tbl b on a.idb.id;
union
select a.id,b.id from tbl
I'm looking at a routine / script to create the fixtures like
team 1 vs team 2
team 3 vs team 4
team 5 vs team 6 etc
On Thu, Aug 19, 2010 at 3:44 PM, Peter Brawley
peter.braw...@earthlink.net wrote:
I'm tasked with generating a list of fixtures from a table of teams,
whereby
each
1 - 100 of 1017 matches
Mail list logo