Problem With Delimiters In Copy To Clipboard

[stumbler]

Hi-

I want to copy the result of:

select sku from products where vendor_stock_no like '99-%';

which yields four lines.

Using the SQLYog command “Copy all rows to clipboard”,

I've been trying all combinations of options to get a list of values separated by commas,

So that when I paste it back in it looks like this:

123, 456, 789, 012

… but I can't get the commas to show up.

Instead I get: 123456789012

or: 123

456

789…

Of course I have checked the line “Fields terminated by” and put a comma in the box.

What have I missed? This is using SQLYog 5.13 on MySQL 5.0.24.

[peterlaursen]

Please see attached image! So simple really if I understand correct!

It is the LINES that will have to be terminated with comma.

As there is only a single value in every line the settings for FIELDS don't take any effect!

[stumbler]

peterlaursen wrote on Sep 6 2007, 08:27 PM:

Please see attached image! So simple really if I understand correct!

It is the LINES that will have to be terminated with comma.

As there is only a single value in every line the settings for FIELDS don't take any effect!

!!! Of course, so simple it escaped me.

Thank you!

[peterlaursen]

better image here!

[Author]

Posts