mysql expanded output

Question

I'm coming from postgresql to mysql, curious if mysql has an expanded output flag similar to that of postgresql?

ie: in psql I could \x to get expanded output

id | name
---+-----
 1 | foo

into

-[ Record ]------
id   | 1
name | foo

how can I do this in mysql?

Answer 1

try SELECT foo FROM bla\G instead of SELECT foo FROM bla;