Toad for MySQL - Community for development, administration, tuning, tips and tricks

Thread: Problems getting Query results from ToadForMySQL into EXCEL by copy & paste

This question is not answered. Helpful answers available: 2. Answered answers available: 1.

Reply to this Thread

Search Forum

Back to Thread List

	Replies: 0 - Pages: 1	Threads: [ Previous \| Next ]

GHodina

Posts: 1
Registered: 10/12/11

Problems getting Query results from ToadForMySQL into EXCEL by copy & paste
Posted: Oct 12, 2011 12:52 AM

The result of the following SQL-Query makes problems on copying it to EXCEL (or even Notepad) via copy & paste:

select winName, substr(GameType,1,1) as Type, min(file) as 'File'

from wins

where winName like '%4%'

and winName not like '%5%'

and winName not like '%4%4%'

and winName not like '%3%'

and winName not like '%2%'

group by winName

;

Only the 1st row was copied. I tested several options
(without header etc).

Remark:
The problem does not occur for the following statement:

select gameNo, gameType, r1,r2,r3,r4,r5

from gesamt

limit 100

The result of this query I got without problems into EXCEL.

Pages: 1

Back to Thread List

Threads: [ Previous | Next ]

Toad World