Month: March 2014

  • Simple MySQL command to show tables and row counts

    Here is simple mysql syntax to show tables with row counts : 1select table_name, table_rows from information_schema.tables where table_schema = "YOUR_DATABASE_HERE";

  • error: Unable to find vcvarsall.bat Python

    Here is a quickfix how to solve error: Unable to find vcvarsall.bat in Python Windows 8. First, please download Visual Studio 8 Then go to Global Enviroment Variable and add new variable : VS90COMNTOOLS (key) and VS110COMNTOOLS (value) Or running this on command prompt : 1SET VS90COMNTOOLS=%VS110COMNTOOLS%

  • Solve error: Unable to find vcvarsall.bat for MySQLDB python

    When we install django and mysql in Windows 8, there is possibility we got this errors : 1error: Unable to find vcvarsall.bat To solve this issue, just download MySQL-Python in : http://www.lfd.uci.edu/~gohlke/pythonlibs/#mysql-python If you’re using virtualenv, you need to copy MySQLDB packages into virtualenv Lib/site-packages.

  • Setup Pentaho Development in Windows 8

    Here is tutorial how to setup Pentaho in Windows 8. First, please go to pentaho community website and download the packages from there. Make sure you have Java JDK installed. 1. Pentaho business analytics platform 2. Kettle – Spoon In this case, we use MySQL for source (input). We need to download and install connector […]