ST Alpha - "Anyone familiar with string sort order in MySQL?" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 155

Anyone familiar with string sort order in MySQL?

Posted by GregW (aka not2fast) Aug 23 '12, 13:24

I need to perform a sort using the linux sort command that will put a file in the same order they would be found in MySQL using a BETWEEN 'stringa' and 'stringb' predicate.

Any idea how I would do that?

Responses:

as far as I know, ORDER BY fieldname and "sort" should be the same; otherwise try "sort -d" -- nm - Beryllium Aug 23, 13:27
why not just import them into a temp table and sort them in mysql directly? -- nm - oblique Aug 23, 13:27 11
- I keep running out of sort work space when using the Order By. So what I really need is a way to run 10 simultaneous queries against a 200 million - GregW Aug 23, 13:30 9
  - have you looked into views? -- nm - Beryllium Aug 23, 13:31 8
    - No, what would that look like? -- nm - GregW Aug 23, 13:33 7
      - I forget the exact syntax, but it's like a table that represents a query - so you could make a query that selects the subset, - Beryllium Aug 23, 13:36 6
        
        I don't know what you mean by 'selects the subset'. Right now, I am selecting the whole table into a file and sorting the file. - GregW Aug 23, 13:47 5
        
        SELECT * FROM table LIMIT 40000000,60000000 ORDER BY whatever. What is your requirement for sorting? - oblique Aug 23, 13:52 3
        
        Thanks, I will try that. It isn't the time needed, but it apparently keeps running out of space even though I have over 100G free. - GregW Aug 23, 13:57 1
        
        very strange. How big is the field you are sorting on, or what datatype is it? -- nm - Beryllium Aug 23, 14:09
        
        Yes, indexes can speed up sorting (and even just selecting) -- nm - Beryllium Aug 23, 13:53
        
        using LIMIT and OFFSET, yes -- nm - Beryllium Aug 23, 13:50
- This would be the most reliable solution. -- nm - Beryllium Aug 23, 13:28

Post a message top

Anyone familiar with string sort order in MySQL?

Replies are disabled on threads older than 7 days.