How to export data from MySQL select command. Saved for my reference
Read more...My MySQL favorite dump command
In MySQL on May 4th, 2011
My favorite MySQL command line Dumps whole database table into mydb_mytable.sql file: mysqldump -umyuser -pmypass –skip-lock-tables -h 127.0.0.1 –databases mydb –tables mytable > mydb_mytable.sql Dumps whole database into mydb.sql file: mysqldump -umyuser -pmypass –skip-lock-tables -h 127.0.0.1 –databases mydb > mydb.sql
Read more...Reset MySQL root password
What do you do if you forget password of root user of MySQL database? Here’s how reset root password.
Read more...CrossTab query (Pivot Table or Transformation of rows into columns)
In MySQL on February 7th, 2011
CrossTab query is amazing, which helps generating reports and play with aggregate values. Excel/Ms Access gives nice user interface for Pivot Table. It’s way to transfer rows into column. It is more often used to generate matrix form of report. Some real-life example: 1. Give me last 3 months sales report product wise. (It may look [...]
Read more...