Skip to content

Instantly share code, notes, and snippets.

@jrran90

jrran90/MySQLCheatSheet.md

Last active November 14, 2019 01:54
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jrran90/e789bc91e5df3de7e2a3a5a080b7e7ee to your computer and use it in GitHub Desktop.
Save jrran90/e789bc91e5df3de7e2a3a5a080b7e7ee to your computer and use it in GitHub Desktop.
Download ZIP
MySQL Cheatsheet
Raw
MySQLCheatSheet.md

MySQL CheatSheet

This can be viewed thru mysql help or if using linux, try man mysql

ego          (\G) Send command to mysql server, display result vertically.

Example:

mysql> SELECT * FROM sometable \G;

Adding a pager

mysql> pager less -S Then the time you do a query you can able to scroll the result.

And if you're done with the page do this:

`mysql> nopager

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment