Pro-Tips

Stuff you wish would have been part of your welcome to earth package.

Pretty print (go)

Super handy when you have lots of data on a smaller screen. the ”G” statement terminator will display the results of your SELECT statement in a vertical way.

MariaDB [oncall]> select * from emails \G
*************************** 1. row ***************************
   email_id: 1
incident_id: 88
    headers: testheader
    message: message
  send_time: 2018-02-08 21:32:44
*************************** 2. row ***************************
   email_id: 2
incident_id: 88
    headers: testheader
    message: message
  send_time: 2018-02-08 21:32:44

In case you would like to learn a bit more about this, I have found the following StackExchange topic where in particular the answer from “Gavin Jackson” is very informative on the topic.

https://stackoverflow.com/questions/2277014/why-the-g-in-select-from-table-name-g