60 row max displayed in sql results window [message #654072] |
Sun, 13 February 2011 20:35  |
Eclipse User |
|
|
|
Have a 1000+ row table that is only displaying the first 60 rows in the sql results window. Nothing constraining the rows from the sql perspective, check preferences, Changed max row count to 0 (unlimited?) and max display row row count to 1000000. No help. MYSQL workbench is able to query the table fine using the same sql. What am I doing wrong?
|
|
|
|
|
Re: 60 row max displayed in sql results window [message #655024 is a reply to message #654072] |
Thu, 17 February 2011 21:24  |
Eclipse User |
|
|
|
Greetings,
My stupidity. My loaded .csv had some missing dates that apparently prevent the query from running if you include that row. Interestingly, its stops the entire result set, not just the records with invalid dates. I have worked through my date issues using something like; date_closed = if(strcmp(@date_closed,''),STR_TO_DATE(trim(@date_closed), '%m/%d/%Y'),NULL). Setting it to NULL, which is what I thought STR_TO_DATE did if you found invalid dates, fixed this issue. Go figure. I am now working an EXPORT issue from the legacy DB that creates .CSV's that wrap if a new line or carriage return is embedded in a text field. I plan on exporting it in HEX and then converting it back to VARCHAR to keep the desire formatting. Ohhh what fun! Thanks for all the ideas!
|
|
|
Powered by
FUDForum. Page generated in 0.33930 seconds