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