Quotable Quote
Blog
Latest posts from my blog - the gsm orbital
Volkswagen India – Worst Customer Service
You are in a lot of excitement when you buy a new car. Sometimes, things can go horribly wrong due to the cunningness of the salespeople or the company selling you the car. A similar experience happened with me during the purchase of my new car. Here’s what has happened till now and the way the customer service works for Volkswagen in India.
I bought a Volkswagen Vento in January 2012, from Bhasin Motors / Volkswagen Delhi South, South Extn., New Delhi. At the time of selling t...
MySQL: Sort By Column Values
In MySQL, sorting the data using columns can easily be done by using the ORDER BY clause. Recently, I came across a requirement where I had to sort the data according to the specific values of a column. For example, if a column has the numbers written as words (one, two, three etc.), the values need to be sorted according to their numerical equivalent rather than the default alphabetical sorting.
By default, the ORDER BY clause will sort data using alphanumeric sorting. But there is a...
MySQL: Exporting Selective Columns to CSV
There are many to export large data sets from MySQL in CSV. If you need data for the complete database or a table in the database, the 'mysqldump' command is a great solution. But sometimes you might need to just export a subset of columns in the database, filtered by where clause. This can be achieved by using the SELECT ... INTO clause. It lets you specify the columns you need for your CSV and you can easily use aggregate functions (SUM, AVG etc.), WHERE clause, GROUP BY clause, ORDER BY claus...