[Ritesh]

peterlaursen wrote on May 6 2005, 04:10 AM:

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

SQLyog does not send any new query to the MySQL server. It just reads the data from the result pane 😀

[Ritesh]

From the MySQL Docs at:

http://dev.mysql.com/doc/mysql/en/load-data.html

Quote:

FIELDS [OPTIONALLY] ENCLOSED BY controls quoting of fields. For output (SELECT … INTO OUTFILE), if you omit the word OPTIONALLY, all fields are enclosed by the ENCLOSED BY character. An example of such output (using a comma as the field delimiter) is shown here:

“1”,”a string”,”100.20″

“2”,”a string containing a , comma”,”102.20″

“3”,”a string containing a ” quote”,”102.20″

“4”,”a string containing a “, quote and comma”,”102.20″

If you specify OPTIONALLY, the ENCLOSED BY character is used only to enclose CHAR and VARCHAR fields:

1,”a string”,100.20

2,”a string containing a , comma”,102.20

3,”a string containing a ” quote”,102.20

4,”a string containing a “, quote and comma”,102.20

Note that occurrences of the ENCLOSED BY character within a field value are escaped by prefixing them with the ESCAPED BY character. Also note that if you specify an empty ESCAPED BY value, it is possible to generate output that cannot be read properly by LOAD DATA INFILE. For example, the preceding output just shown would appear as follows if the escape character is empty. Observe that the second field in the fourth line contains a comma following the quote, which (erroneously) appears to terminate the field:

[Ritesh]

Thanks to all for taking the time and having a discussion on the issue.

I have forwarded it to my development team. I believe its already in the TO-DO list of v4.1.

[Ritesh]

BTW, have you people tried the latest BETA 5 of v4.06. This BETA fixes couple of bugs which were identified while working on the above issue.

[Ritesh]

@jayshi and @sergius: Please mail me the screenshot of your Escape Character window. I believe this bug occurs only with one particular value(s) of escape characters.

[Ritesh]

I have added it to the TO-DO list of v4.1.

[Ritesh]

@jayshi: I got your mail. Can you mail me the screenshot of your escape character window?

[Ritesh]

Quote:

Which version of MySQL and SQLyog are you using?

Can you mail me your table structure and some sample data?

Without sample data we are not able to reproduce the error 🙁

[Ritesh]

No.

We are still working on the issue.

[Ritesh]

Thanks.

I have forwarded it to my development team. It will be fixed in v4.07.

[Ritesh]

jayshi wrote on May 4 2005, 07:29 PM:

Glad we are on the same page, Sorry I did not come to check this post as I was very busy with month end project.  I was just using default setting

“Lines Terminated By n” and for Variable Length, I have “Field Terminated By t”, so I was losting my last bit of data.

Thanks.

Can you mail me a screenshot of your Escape Character window? I am still not able to reproduce the error where data is being truncated 🙁

[Ritesh]

If I use $, I get:

Quote:

'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

There is no ' at the end (which is a bug) though there is no truncation of data either.

We will fix the issue with $ and $$$.

[Ritesh]

Here are the steps that I followed:

and the result:

[Ritesh]

Quote:

I still have an old sqlyog 3.11 installed. Results with this one are sligthly different…

There has been lot of changes on that feature after 3.11. Many known bugs have been fixed.

[Ritesh]

peterlaursen wrote on May 4 2005, 09:46 AM:

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

I saw the post but I am not able to reproduce the bug! Its working for me.

[Author]

Posts