Python - How to install downloaded packages with Anaconda

conda install --offline --verbose c:\filename.tar.bz2

MySQL - Command line to display a list of all views in a given database

mysql -NBA -h the_host -u user_name -p -D database_name -e "SHOW FULL TABLES IN database_name WHERE TABLE_TYPE LIKE 'VIEW';"

Cleaner, only 1 column:

mysql -NBA -h the_host -u user_name -p -D database_name -e "SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_TYPE LIKE 'VIEW' AND TABLE_SCHEMA LIKE 'database_name';"

MySQL - Command line to display a list of all tables

mysql -NBA -h the_host -u user_name -p -D database_name -e 'show tables'