Forum Replies Created
-
AuthorPosts
-
ronjeremy_69
Participantpeterlaursen wrote on Apr 21 2006, 08:51 PM:It is no issue to insert the 'order by' into the database. You can do yourself. Common combinations could be added like 'select * from' etc..awesome, ill give it a try!
peterlaursen wrote on Apr 21 2006, 08:51 PM:BTW: I think user entries (priority settings, user's own keywords and phrases) should be in a seperate database file ideally …Yep i agree, so you dont have to redo it every new SQLyog version
ParticipantOne other thing i forgot to mention regarding the keywords, is that it looks like there is no “clause” functionality. The biggest example i can think of is the “ORDER BY” clause.
Typing “ORDE” [TAB] inserts “ORDER”, but then you have to go on and type “BY” manually. I feel the entire “ORDER BY” should be a keyword option. Correct me if I'm wrong, but I dont think “ORDER” is used anywhere in mysql without being accompanied by “BY”?
Ritesh wrote on Apr 21 2006, 08:30 PM:Nice suggestion. Let me think about it and we can start a discussion thread on how to improve the Autocomplete feature.awesome, thanks!
ParticipantI experience the same thing — but not only that, another issue with the “Table Data” tab is that it will completely freeze up if I want to browse more than several thousand records.
A nice solution ot this would be to implement a feature that I have been asking for a year now — an option “Show Table Data In Text”. I can browse hundreds of thousands of records in text mode very quickly. I almost NEVER use the “Table Data” tab to update records, so the grid is pretty much pointless. Copying text from multiple-columns in the grid is a royal pain. The only advantage I can see for the grid is to always be able to see the column names no matter how far down in the data you scroll. Perhaps you can somehow also have an option to make the column names “sticky” in text mode as well?
Participantpeterlaursen wrote on Jan 20 2006, 01:47 AM:I feel like to repeat myself <_< I do not understand why this is so important! It is so easy to issue a 'select *' and have results shown in text from RESULT-pane. With the most recent SQLyog's it is event more simple then before: you can right-click a table and paste a select statement. I also ABSOLUTELY don't understand that anyone has the need to have a COMPLETE TABLE shown in text. But they can from RESULT -pane if they want. To me it would be fine if Ritesh declared that this will not be implemented for the near future. There a hundreds of requests pending that are more important to spend time with in my opinion. Should I request something it would be that a similar popup-menu item was available for VIEWs.[post=”8525″]<{POST_SNAPBACK}>[/post]I couldn't disagree more. For a light user who issues maybe ten or twenty queries a day, sure Peter's way is fine. But for a professional developer, who has over 90 databases and thousands of tables, and who needs to look at different table data hundreds or even thousands of times per day in the development process, it is ESSENTIAL to be able to just click on a table and have it displayed as text with ONE CLICK. The issue here is SPEED and EFFICIENCY. For development work, it is often much faster to see the entire table and browse to some records of interest than it is to type a select…where query.
I like my query editor nice and clean with queries that I actually need. I shouldn't have to paste hundred's of select * statements that ill probably only use once.
There are two main reasons for text: The first and foremost is that the text output is several orders of magnitude faster to scroll and navigate than the grid, especially when you have more records than the buffer is showing. The second is that text-based display allows you to selectively highlight and copy adjacent fields to the clipboard, whereas copying text with the grid is cumbersone.
These little things amount to hours of time saved for heavy database professionals. There isnt a feature tht would be more valuable than an option “Show Table Data In Text”
ParticipantQuote:I'm confused. You mean like CTRL-L? Or is there something more?See this older thread for details:
-
AuthorPosts
