Forum Replies Created
-
AuthorPosts
-
peterlaursen
Participantone more crazy ex that works fine…
35612,'@'Papa@' John DeFrancesco','Hip Cake Walk','Song For My Father'=====35617,'@'Papa@' John DeFrancesco','Hip Cake Walk','Latin Groove'=====35616,'@'Papa@' John DeFrancesco','Hip Cake Walk','Back At The Chicken Shack'=====35615,'@'Papa@' John DeFrancesco','Hip Cake Walk','Moanin@''=====35614,'@'Papa@' John DeFrancesco','Hip Cake Walk','High Rider'=====35611,'@'Papa@' John DeFrancesco','Hip Cake Walk','Freddy The Freeloader'=====35610,'@'Papa@' John DeFrancesco','Hip Cake Walk','The Cat'=====35618,'@'Papa@' John DeFrancesco','Hip Cake Walk','Hip Cake Walk'=====35613,'@'Papa@' John DeFrancesco','Hip Cake Walk','Milestones'=====26714,'12 Apostles Church Choir','The Rough Guide to South African Gospel','Izindaba'=====27533,'3eme concours flamenco','Nimes','Guajira'=====25108,'3eme concours flamenco','Nimes','Taranta'=====25235,'3eme concours flamenco','Nimes','Solea'=====1893,'3eme concours flamenco','Nimes','Danse'=====523,'3eme concours flamenco','Nimes','Solea'=====3504,'3eme concours flamenco','Nimes','Danse'=====6931,'3eme concours flamenco','Nimes','Solea'=====9066,'3eme concours flamenco','Nimes','Tonas'=====8084,'3eme concours flamenco','Nimes','Buleria'=====9741,'3eme concours flamenco','Nimes','Taranta'
here @ is escape character and comes in use because of artist name: 'Papa' John DeFrancesco that contains the ' -character that is also used as field delimiter. And line delimiter is here: ===== (as it should be)
Participanta correction of my last post
And that works too (with another crazy example – not 3-charcter delimiter)
>>
And that works too (with another crazy example – NOTE 3-character delimiter)
(NOTE: “NOTE” not “NOT” 🙄 )
Participantthanks for the explanation!
And that works too (with another crazy example – not 3-charcter delimiter)
1+”John McLaughlin”+”The Heart of Things”|$|2+”Danu”+”The Road Less Traveled”|$|3+”Bud Powell”+”A Portrait of Thelonious”|$|4+”Mississippi John Hurt”+”Revisited”|$|5+”Andy Statman Klezmer Orchestra”+”Klezmer Suite”|$|6+”Herbie Mann”+”Memphis Underground”|$|7+”Kek Lang”+”Chants Room”|$|8+”Astor Piazzolla”+”Concierto de Nascar”|$|9+”Grady Tate”+”All Love/Grady Tate Sings”|$|10+”The Mills Brothers”+”Chronological, Vol. 3″|$|11+”Cubanismo”+”Reencarnacion”|$|12+”Torben WestergÃ¥rd”+”Brazilian Heart”|$|13+”Duke Ellington”+”The Private Collection vol. 7″|$|14+”Kassé-Mady Diabaté”+”Kassi Kasse”|$|15+”Arne Forchhammer Trio”+”Assimilation”|$|16+”Vieja Trova Santiaguera”+”Hotel Asturias”|$|17+”Sergio Mendes”+”Brasileiro”|$|18+”Fernando Tarres”+”The Outsider”|$|19+”Jan Johansson”+”Folkvisor”|$|20+”Sonny Boy Williamson”+”The Bluebird Blues”
But does that mean then that sqlyog will send a NEW query to the MySQLseserver ??
That could be important to know in the case data have changed in the meantime …
(I thougt it just read from the result pane!)
ParticipantIt's perfect here with the inputs that are within the reach of my imagination …
Just one crazy example
“'Papa' John DeFrancesco”+”Hip Cake Walk”+”Jazz”||”12 Apostles Church Choir”+”The Rough Guide to South African Gospel”+”World”||”3eme concours flamenco”+”Nimes”+”Flamenco”||”A Falta De Pan”+”Rough Guide to the Music of Spain”+”Folk/Fusion”||”Aaron Neville”+”Nature Boy: The Standards Album”+”Jazz”||”Abaji”+”Rêves d'Oasis: Desert Blues 2 (1 of 2)”+”Afrikansk/Vest”||”Abaji”+”Oriental Voyage”+”Folk/Fusion”||”Abbey Lincoln”+”A Turtle's Dream”+”Jazz”||”Abbey Lincoln”+”Abbey Is Blue”+”Jazz”||”Abbey Lincoln”+”Over the Years”+”Jazz”||”Abdel Gadir Salim”+”Popular Music of Sudan”+”Afrikansk/Arabisk”||”Abdel Gadir Salim”+”Ambiances du Sahara: Desert Blues (1 of 2)”+”Afrikansk/Vest”||”Abdel Gadir Salim”+”Ambiances du Sahara: Desert Blues (2 of 2)”+”Afrikansk/Vest”||”Abdel Halim Hafez”+”Rough Guide to the Music of Egypt”+”World”||”Abdou”+”The Rough Guide to Rai”+”Folk/Fusion”||”Abdullah Ibrahim”+”African Horns”+”Jazz”||”Abdullah Ibrahim”+”African Magic”+”Jazz”||”Abdullah Ibrahim”+”African Piano”+”Jazz”||”Abdullah Ibrahim”+”African River”+”Jazz”||”Abdullah Ibrahim”+”Anatomy of a South African Village”+”Jazz”
BTW … what does it mean to check the “optionally” box – I can't reproduce any difference whether this box is check or not …
ParticipantGive me ten minutes to test …
Participant> yes Ritesh, probably …
but try using the default values of the sqlyog program (if they have not been changed by the user yet) !
and besides that gives me a chance to say the the escapes the program proposes when you use the “copy from clipboard” for the first time are rather WEIRD.
I believe that I can make out that these defaults will generate an output that fits for use in a PHP-script, but still … why ??
Participantthey are in the proces of moving the forum to another server, and the new one isn't quite configured yet …
And I don't know if it will ever accept PNG's … but at least JPG's should work very soon.
Sergius could you send a screenshot of your “Escape Character window” to Ritesh then …
ParticipantIt's a good thing when communication is a success … 😀
ParticipantActually if I let “lines terminated by” = $$$
it returns
'John McLaughlin','The Heart of Things','Jazz'$$$'Danu','The Road Less Traveled','Folk'$$$'Bud Powell','A Portrait of Thelonious','Jazz'$$$'Mississippi John Hurt','Revisited','Blues'$$$'Andy Statman Klezmer Orchestra','Klezmer Suite','Klezmer'$$$'Herbie Mann','Memphis Underground','Jazz/Soul/Funk'$$$'Kek Lang','Chants Room','Folk/Trad.'$$$'Astor Piazzolla','Concierto de Nascar','Tango'$$$'Grady Tate','All Love/Grady Tate Sings','Jazz'$$$'The Mills Brothers','Chronological, Vol. 3','Jazz'$$$'Cubanismo','Reencarnacion','Latin'$$$'Torben Westergård','Brazilian Heart','Latin'$$$'Duke Ellington','The Private Collection vol. 7','Jazz'$$$'Kassé-Mady Diabaté','Kassi Kasse','Afrikansk/Vest'$$$'Arne Forchhammer Trio','Assimilation','Jazz'$$$'Vieja Trova Santiaguera','Hotel Asturias','Latin'$$$'Sergio Mendes','Brasileiro','Latin'$$$'Fernando Tarres','The Outsider','Jazz/Fusion'$$$'Jan Johansson','Folkvisor','Jazz'$$$'Sonny Boy Williamson','The Bluebird Blues','Blues'$
ParticipantYEAH ..
but what if “lines terminated by” is only ONE character ??
ParticipantI don't doubt there has been a lot of changes in the code.
The only reason why I brought it in, was that the new design of the result-pane from 4.05 and onwards could have affected behaviour of the “copy to clipbord”-feature.
Participant>>> Ritesh
Do you still have the data that I sent you to test the “right alignment with GROUP clause”-issue ?
It's the same data that I use in this example. Could you try these ?
What else will we do then to get closer to the problem ?? 😮
You are welcome to send me some sample data that works with your installation, and I'll test on my system.
ParticipantI still have an old sqlyog 3.11 installed. Results with this one are sligthly different…
“lines teminated by” checked with value: $$
John McLaughlin|The Heart of Things|Jazz|$$Danu|The Road Less Traveled|Folk|$$Bud Powell|A Portrait of Thelonious|Jazz|$$Mississippi John Hurt|Revisited|Blues|$$Andy Statman Klezmer Orchestra|Klezmer Suite|Klezmer|$$Herbie Mann|Memphis Underground|Jazz/Soul/Funk|$$Kek Lang|Chants Room|Folk/Trad.|$$Astor Piazzolla|Concierto de Nascar|Tango|$$Grady Tate|All Love/Grady Tate Sings|Jazz|$$The Mills Brothers|Chronological, Vol. 3|Jazz|$$Cubanismo|Reencarnacion|Latin|$$Torben Westergård|Brazilian Heart|Latin|$$Duke Ellington|The Private Collection vol. 7|Jazz|$$Kassé-Mady Diabaté|Kassi Kasse|Afrikansk/Vest|$$Arne Forchhammer Trio|Assimilation|Jazz|$$Vieja Trova Santiaguera|Hotel Asturias|Latin|$$Sergio Mendes|Brasileiro|Latin|$$Fernando Tarres|The Outsider|Jazz/Fusion|$$Jan Johansson|Folkvisor|Jazz|$$Sonny Boy Williamson|The Bluebird Blues|Blues|$
“lines teminated by” checked with value: $
John McLaughlin|The Heart of Things|Jazz|$Danu|The Road Less Traveled|Folk|$Bud Powell|A Portrait of Thelonious|Jazz|$Mississippi John Hurt|Revisited|Blues|$Andy Statman Klezmer Orchestra|Klezmer Suite|Klezmer|$Herbie Mann|Memphis Underground|Jazz/Soul/Funk|$Kek Lang|Chants Room|Folk/Trad.|$Astor Piazzolla|Concierto de Nascar|Tango|$Grady Tate|All Love/Grady Tate Sings|Jazz|$The Mills Brothers|Chronological, Vol. 3|Jazz|$Cubanismo|Reencarnacion|Latin|$Torben Westergård|Brazilian Heart|Latin|$Duke Ellington|The Private Collection vol. 7|Jazz|$Kassé-Mady Diabaté|Kassi Kasse|Afrikansk/Vest|$Arne Forchhammer Trio|Assimilation|Jazz|$Vieja Trova Santiaguera|Hotel Asturias|Latin|$Sergio Mendes|Brasileiro|Latin|$Fernando Tarres|The Outsider|Jazz/Fusion|$Jan Johansson|Folkvisor|Jazz|$Sonny Boy Williamson|The Bluebird Blues|Blues|
“lines teminated by” checked but empty
John McLaughlin|The Heart of Things|Jazz|Danu|The Road Less Traveled|Folk|Bud Powell|A Portrait of Thelonious|Jazz|Mississippi John Hurt|Revisited|Blues|Andy Statman Klezmer Orchestra|Klezmer Suite|Klezmer|Herbie Mann|Memphis Underground|Jazz/Soul/Funk|Kek Lang|Chants Room|Folk/Trad.|Astor Piazzolla|Concierto de Nascar|Tango|Grady Tate|All Love/Grady Tate Sings|Jazz|The Mills Brothers|Chronological, Vol. 3|Jazz|Cubanismo|Reencarnacion|Latin|Torben Westergård|Brazilian Heart|Latin|Duke Ellington|The Private Collection vol. 7|Jazz|Kassé-Mady Diabaté|Kassi Kasse|Afrikansk/Vest|Arne Forchhammer Trio|Assimilation|Jazz|Vieja Trova Santiaguera|Hotel Asturias|Latin|Sergio Mendes|Brasileiro|Latin|Fernando Tarres|The Outsider|Jazz/Fusion|Jan Johansson|Folkvisor|Jazz|Sonny Boy Williamson|The Bluebird Blues|Blues
“lines teminated by” unchecked
John McLaughlinThe Heart of ThingsJazzDanuThe Road Less TraveledFolkBud PowellA Portrait of TheloniousJazzMississippi John HurtRevisitedBluesAndy Statman Klezmer OrchestraKlezmer SuiteKlezmerHerbie MannMemphis UndergroundJazz/Soul/FunkKek LangChants RoomFolk/Trad.Astor PiazzollaConcierto de NascarTangoGrady TateAll Love/Grady Tate SingsJazzThe Mills BrothersChronological, Vol. 3JazzCubanismoReencarnacionLatinTorben WestergårdBrazilian HeartLatinDuke EllingtonThe Private Collection vol. 7JazzKassé-Mady DiabatéKassi KasseAfrikansk/VestArne Forchhammer TrioAssimilationJazzVieja Trova SantiagueraHotel AsturiasLatinSergio MendesBrasileiroLatinFernando TarresThe OutsiderJazz/FusionJan JohanssonFolkvisorJazzSonny Boy WilliamsonThe Bluebird BluesBlue
Participant>>> Ritesh
look at my data!! (10:51)
the VERY LAST ENDING should be “…… |Blues” but with a single character as line-delimiter it is only “……|Blue”
ParticipantBut it occurs only with “variable length”-setting and not “fixed length”
Can you live with putting in 2 characters as line delimiters until it's fixed ??
-
AuthorPosts
