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

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.