If you ever find yourself using MySQL via command line and end up with something like this:
And thought there must be another way, well here it is: Use \G instead of ; at the end of your select command.
For example:
select * from CHARACTER_SETS\G
Below is an image of the output from this select:
Happy Querying!
Like this:
Like Loading...
Related
Published by Matt Cockayne
Matt is the currently working as a Senior Linux Sysadmin for the Medicines Discovery Catapult and also and Scout Leader.
Having tried his hand a few different careers he finds that he is happiest working with code. As a framework contributor and serial tinkerer Matt has spent a long time working on being the best Software Engineer he can be.
As a Scout Leader he spends a lot of his time devoted to teaching valuable life skills to kids aged 7-18. He is a firm believer that being a Good Scout and Great Developer go hand in hand.
View all posts by Matt Cockayne