Skip to content

Instantly share code, notes, and snippets.

@gagomes

gagomes/mysql-hive-one-liners.md

Last active March 20, 2017 14:55
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 gagomes/eef83aa08f2cd7253f409ac9f8ff77a1 to your computer and use it in GitHub Desktop.
Save gagomes/eef83aa08f2cd7253f409ac9f8ff77a1 to your computer and use it in GitHub Desktop.
Download ZIP
notes
Raw
mysql-hive-one-liners.md

MySQL

list all tables from all databases (Taken from a SO post)

SELECT table_name, table_schema AS dbname FROM INFORMATION_SCHEMA.TABLES
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment