Here is simple mysql syntax to show tables with row counts :
select table_name, table_rows from information_schema.tables where table_schema = "YOUR_DATABASE_HERE";
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 :
When we install django and mysql in Windows 8, there is possibility we got this errors :
error: Unable to find vcvarsall.bat
To solve this issue, just download MySQL-Python in :
If you’re using virtualenv, you need to copy MySQLDB packages into virtualenv Lib/site-packages.
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 from :
1. Download independent platform from http://dev.mysql.com/downloads/connector/j/ (Zip files)
2. Copy the .jar file and paste it in your Lib folder (eg: D:\pentaho\design-tools\data-integration\lib)
3. Restart your spoon