Note: These are not all for the command line. There are so many other tricks we learn along the way and they are seldom documented. If you know others please throw them in the comments. MySQL Tip: When you run a normal query in MySQL prompt, if your table is larger than your monitor, you get a jumbled mess of data. It is incredibly hard to read and makes for slow going. The following command replaces the common “;” with a “\G” to complete your command and displays the data in a clean vertical fashion. mysql> select * from stores where id = 1\G *************************** 1. row *************************** id: 1 company_id: 3 name: Cool Hunting verified: 0 customer_service_number: (310) 698-3333[…]