Re: need help from the list admin

. 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

Re: need help from the list admin

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

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

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

Re: need help from the list admin

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

Re: need help from the list admin

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

Re: need help from the list admin

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

Re: need help from the list admin

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

RE: need help from the list admin

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

Re: need help from the list admin

/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

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

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

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

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

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

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

Re: need help from the list admin

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

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

;> > > 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

Re: need help from the list admin

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

Re: need help from the list admin

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

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: 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 rep

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 Mailin

Re: need help from the list admin

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

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 ?

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

need help from the list admin

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

Re: need help from the list admin

(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

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

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-

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

129521671 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: need help from the list admin

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

Re: need help from the list admin

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

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

(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

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: need help from the list admin

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

Re: need help from the list admin

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

Re: need help from the list admin

"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 >

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

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

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

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

does anyone else have problems sending mails to this list ?

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

Re: Unsubscribing my sql mailing list

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

Unsubscribing my sql mailing list

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

Re: MySQL 5.5.33 History list not purging?

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

RE: MySQL 5.5.33 History list not purging?

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

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 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

Re: MySQL 5.5.33 History list not purging?

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

Re: MySQL 5.5.33 History list not purging?

/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

RE: how to list record in column (instead of a row)

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

Re: how to list record in column (instead of a row)

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

how to list record in column (instead of a row)

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

Re: how to list record in column (instead of a row)

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

need list of country ISO code to demonyms

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

Re: need list of country ISO code to demonyms

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

RE: need list of country ISO code to demonyms

, 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

RE: need list of country ISO code to demonyms

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

Re: need list of country ISO code to demonyms

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

ATT: List OWNER/MODERATOR

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*

Re: ATT: List OWNER/MODERATOR

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

Re: ATT: List OWNER/MODERATOR

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

Re: LISTADMIN: Precedence: bulk / Precedence: list

- 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

List of global/session variables (@myvar)

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

Parent/Child - Linked List

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

Re: Parent/Child - Linked List

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

Re: Parent/Child - Linked List

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

Re: Parent/Child - Linked 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

Re: Parent/Child - Linked List

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

Re: Parent/Child - Linked List

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

Schema list

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

Re: Schema list

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

RE: WHERE does not work on calculated view field - Found word(s) list error in the Text body

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

Re: WHERE does not work on calculated view field - Found word(s) list error in the Text body

-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

RE: WHERE does not work on calculated view field - Found word(s) list error in the Text body

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

Re: WHERE does not work on calculated view field - Found word(s) list error in the Text body

' 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

Re: WHERE does not work on calculated view field - Found word(s) list error in the Text body

- 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

RE: WHERE does not work on calculated view field - Found word(s) list error in the Text body

@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

Re: WHERE does not work on calculated view field - Found word(s) list error in the Text body

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

Re: SPAM: please remove gregario.es from the 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

SPAM: please remove gregario.es from the list

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

`List-Unsubscribe'

Hi Please unsubscribe my ID from the list Best Pratyaksh Nidhi Sharma

`List-Unsubscribe'

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

List archive?

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

Re: List 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

Re: List archive?

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

Posting to the mailing list.

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

Get max ID of each item in a list

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

Re: Get max ID of each item in a list

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

mysql vs postgresql -- is this list accurate?

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

Re: mysql vs postgresql -- is this list accurate?

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

Re: Fixture List generation using MySQL

. 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

Re: Fixture List generation using MySQL

... 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

Fixture List generation using MySQL

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

Re: Fixture List generation using MySQL

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

Re: Fixture List generation using MySQL

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   2   3   4   5   6   7   8   9   10   >