News for hackers. Stuff that matters.
Re:Show HN: Select Star SQL, an interactive SQL book by nexxer on Wednesday September 12, 2018 @09:38AM (#17968565)
In the clients I've used (SQLYog, Mysql Workbench), aliasing a table lets you use autocomplete when referencing that alias followed by a dot.

So, I will start with a SELECT * FROM myTable t, then go back and replace * with t.<columns appear here>.

I'll use the same in other places in the query like WHERE conditions.

There are no comments on this comment yet.