7 ms·
It’s certainly not a feature. A lot of important SQL usage is ad-hoc queries, and they are more annoying to type than they should be.
by strokirk 3y ago
It’s certainly not a feature. A lot of important SQL usage is ad-hoc queries, and they are more annoying to type than they should be.
- mulmen 3y agoI don’t understand how changing the order of the clauses makes a query easier to type.
- spullara 3y agoIf you have auto-complete it can see what table you are using and complete the column names. Starting with SELECT it could be any column in the database.
- nhinck2 3y agoI see this complaint stated over and over again, how hard is it really to type SELECT * FROM x a and then go back?
- mulmen 3y agoHuh. I have been doing this for like 15 years and never have a problem. Text editors like Sublime Text suggest names based on the content of the file. SQL Developer, SQLWorkbench, and DataGrip all seem to handle it just fine.
- spullara 3y agoIt will suggest names that aren't in the table you are going to query unless it is psychic.
- mulmen 3y agoIt is psychic in the sense that it makes educated guesses based on previous entries and the current database and schema. This is the same kind of educated guess it would make with a table name.