Adame: Rumery: I just want to get latest records for every account_id, put it into text file and p**** it if needed not to ask DB every time

Rumery: Adame, sorry, I read that script wrong.

Rumery: Adame, yep, then please try http://sqlfiddle.com/#!9/0d9edf/3

Adame: Rumery and others: thank you. It seems it works

Lundeen: Ok I every protein has multiple domains, now I have a task where in A I have columns start/stop/seqID/domainID and I want to select only seqID for which domainID are not farer apart than value 30 between stop-start of another domain

Magbitang: Is that possible in mysql ?

Garris: Reller: You can use a join for that. It’s tough to know exactly what you are trying to do.

Rumery: Reller, self-join might work

Pallant: Reller: This would be standard SQL, not MySQL specific.

Mcwhite: Reller: Just imagine you have two rows, r1 and r2. Write the logic that compares r1 with r2, looking for just those pairs of rows that match your criteria. Now use that same logic in your ON clause of the join.

Salvietti: Got this error “ERROR: Query failed. 1054 42S22: Unknown column ‘p***word’ in ‘field list'” from using mysqlfailover, how do I fix this?

Kenekham: There is p***word column in any of the tables. In fact there’s only one test table.

Wedlock: Can I install mysql using aptitude without entering a desired root p***word? Maybe set it in environment variable until installed?

Carley: Hi guys. can you add comment in a column just to give information of what the column represent

Sumey: Baako: See http://dev.mysql.com/doc/refman/5.6/en/create-table.html

Rumery: Baako, search for a COMMENT keyword

Locken: Is there a way to split string values by space into rows in certain column ?

Althouse: Select SUBSTRING_INDEXSUBSTRING_INDEX ‘this is a test’ , ‘ ‘, 1,’ ‘,-1 AS str1, SUBSTRING_INDEXSUBSTRING_INDEX ‘this is a test’ , ‘ ‘, 2,’ ‘,-1 as str2, SUBSTRING_INDEXSUBSTRING_INDEX ‘this is a test’ , ‘ ‘, 3,’ ‘,-1 as str3, SUBSTRING_INDEXSUBSTRING_INDEX ‘this is a test’ , ‘ ‘, 4,’ ‘,-1 as str4;

Wadle: Number of spaces is unknown

Rumery: And max number of them is known?

Soppe: Well could be counted

Rumery: Some reasonable upper limit?

Dolecek: Fun part is that in table domain, domain architecture if I count number of domains per architecture that does not count repeats

Rumery: But is possible to join to a table containing just numbers 1-568 or 1-600 and selecting the proper substring for a given row

Azim: Though there is table architecture with column domains which contains string with domains including repeats

Escott: Create table pfamA_domfam_arch_acc_counts SELECT auto_architecture,architecture_acc,LENGTHarchitecture_acc – LENGTHREPLACEarchitecture_acc, ‘ ‘, ” + 1 AS items from pfamA_domfam_arch_acc;

Carle: Reller: http://gtowey.blogspot.com/2009/12/how-to-fix-comma-separated-list-of-doom.html

Kurgan: Like we said yesterday

Clyatt: Reller: Better don’t store such strings in single column

Hults: Salle, I am not, its given

Clyatt: Reller: Then redesign it

Jabaut: Rumery, so the thing is that I can count them, but I also need to filter out some of them which are again given by another table

Gaerlan: Thats why I would like to unfold that into rows

Birchett: There is a table saying that certain domain is a repeat or motif, I would like to discard those from counting

Clyatt: Reller: Easier to do it in client app

Rumery: Reller, as salle says – just take the time, write a small script and store it properly – it will save you from a lot of headaches of this kind

Gibb: Ok should be possible

Clyatt: Reller: All you need is one more table and simple script to populate it

Rumery: Is a rename table operation fast? unless it would wait on some metadata lock etc