|
Replies:
0
-
Pages:
1
|
|
|
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.
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
