Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

mysql expanded output

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?

like image 871
veilig Avatar asked Nov 12 '10 18:11

veilig


1 Answers

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

like image 131
TomaszSobczak Avatar answered Sep 25 '22 02:09

TomaszSobczak



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!