Mysql Tips

List all tables and count in mysql

SELECT table_name, table_rows FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'emsadmin' order by table_rows asc;

Counting the number of rows in a large table

select table_rows from information_schema.tables where table_name = 'HistoricalAlarm';

Create a csv file using name coloun of Ne Table. 

select name from Ne limit 1,1470 into outfile '/tmp/nelist.csv' fields terminated by ',';

Comments

Post a Comment

Popular posts from this blog

vmWare - Vcenter Server Appliance 5.5 - embedded DB problem

Problem seen: The embedded DB didnt start due to which vCenter configurations like Dswitch, hosts, etc were not available. vSA-173:~ # service vmware-vpxd status vmware-vpxd is stopped tomcat is stopped vSA-173:~ # service vmware-vpxd start Waiting for the embedded database to start up: ............................failed Verifying EULA acceptance: success Executing pre-startup scripts... Updating the vCenter endpoint in the Lookup Service. Intializing registration provider... Getting SSL certificates for https://135.249.34.173:7444/lookupservice/sdk Service with name 'vpxd-vSA-173-81a29e14-9705-47e2-a165-3cacb809fd43' and ID 'local:20165866-25c5-41ac-8e5e-9fc277b7bc6b' was updated. Return code is: Success Starting ldap-server..done Starting vmware-vpxd: success Waiting for vpxd to initialize: .................... .................................^C vSA-173:~ # Traceback (most recent call last):   File "/usr/lib/vmware-vpx/py/wait_for_vpxd.py...
Read more

Installing Pytest on Windows Platform

Go to the Scripts Directory under Python installation C:\>cd Python34\Scripts C:\Python34\Scripts>dir  Volume in drive C is System  Volume Serial Number is C273-3B76  Directory of C:\Python34\Scripts 03/19/2015  10:00 AM    <DIR>          . 03/19/2015  10:00 AM    <DIR>          .. 03/19/2015  10:00 AM            92,008 easy_install-3.4.exe 03/19/2015  10:00 AM            92,008 easy_install.exe 03/19/2015  10:00 AM            91,980 pip.exe 03/19/2015  10:00 AM            91,980 pip3.4.exe 03/19/2015  10:00 AM          ...
Read more

X Forwarding with Putty on Windows

Image
Courtesy  http://www.math.umn.edu/systems_guide/putty_xwin32.html Intro to X Forwarding Unix machines have been able to run software on a remote machine and display the GUI locally for almost two decades. Linux and Mac OS X support X Forwarding with no extra software. Any terminal on Linux should do X Forwarding, Mac users need to run " Applications > Utilities > XTerm ". In a command line terminal run " ssh -Y jdoe@compute.example.edu matlab " and you'll be running matlab on " compute.example.edu " but seeing it on your desktop. Windows users need two pieces of software: an secure shell program (ssh) to establish the remote connection and an X Server to handle the local display. Prerequisites Putty  for SSH Xming  for the XServer Configuring Putty Add Unix hostname Switch Protocol to SSH Type name of session in saved sessions Click 'Save' Expand the 'SSH' tab from the 'Category' list Choose 'X1...
Read more