3 ms·
Unless I have the whole query in my head by the time I've typed "$db->query(", I will indeed start with the FROM by just typing the placeholder SELECT * and the
by lucb1e 7y ago
Unless I have the whole query in my head by the time I've typed "$db->query(", I will indeed start with the FROM by just typing the placeholder SELECT * and then revisiting the asterisk when I'm done with (most of) the query. Somehow that makes it easier, especially with complex queries.
- gigatexal 7y agoI do this too! I thought I was the only one
- mritchie712 7y agoI do this too, so the autocomplete in SeekWell automatically does this, check it out: https://www.loom.com/share/9c7979a163eb4513b3320e6e90c66079 https://www.loom.com/share/9c7979a163eb4513b3320e6e90c66079 If you type just a table name into an empty cell it will autocomplete with a full SELECT statement. e.g. if you typed "pubuser" and selected "public.users" it would autocomplete with: SELECT pu.* FROM public.users AS pu WHERE 1=1 Disclaimer: I built this.