Log In
Create Account
SlickerTalk
Search Archives
The Leaderboard
The FAQ
Login
Create Account
Search
Dr. S. Talk
TT/ST Wiki
How Well Do You Know ...
RSS Feed
Hosting by DigitalOcean
Support ST on Ko-Fi
Links Only
50 Results
100 Results
250 Results
500 Results
1000 Results
5000 Results
2 Weeks
2 Months
6 Months
1 Year
2 Years
5 Years
All Time
Live
Down to Post
Backboards:
Live
________________
1: Dec 1, 17:33
2: Dec 1, 11:23
3: Nov 30, 15:54
4: Nov 30, 09:41
5: Nov 29, 16:44
6: Nov 29, 08:01
7: Nov 28, 16:19
8: Nov 28, 09:42
9: Nov 27, 18:07
10: Nov 27, 12:04
11: Nov 27, 08:26
12: Nov 26, 18:06
13: Nov 26, 12:05
14: Nov 26, 08:29
15: Nov 25, 18:33
16: Nov 25, 11:12
17: Nov 25, 07:08
18: Nov 24, 13:17
19: Nov 23, 18:13
20: Nov 23, 06:17
Posts: 152
In response to
"
It is varchar(22). I don't know why I can't run it with Order By, by I keep getting this error:
"
by
GregW
what is the query that causes that error? -- nm
Posted by
Beryllium (aka grayman)
Aug 23 '12, 15:01
(No message)
Responses:
It is a simple select.
-
GregW
Aug 23, 15:05
6
and what do you want to do with it? -- nm
-
Beryllium
Aug 23, 15:09
5
I am running a tool that extracts the data to my DB2 server where I will use it to load our new database.
-
GregW
Aug 23, 15:14
4
Really? It doesn't use disk files for sorting? -- nm
-
GregW
Aug 23, 15:21
1
mysql might - but since you're invoking it from java, I think it's trying to create an in-memory result set that is too large -- nm
-
Beryllium
Aug 23, 15:22
You might want to forget java and just use mysqldump ... or even the mysql command itself to make a CSV -- (link)
-
Beryllium
Aug 23, 15:19
well, it sounds like what you're telling it to do is "select 200 million rows into RAM", which ... isn't useful. -- nm
-
Beryllium
Aug 23, 15:17
Post a message
top
Replies are disabled on threads older than 7 days.
