Here are the ways you can export tables and databases, each of them have their advantages and disadvantages depending on the task at hand. We will list out each with examples and discuss them. We will assume that the database name is D and table name is T. Going native with SQL and generating an csv from the MySQL console Assuming that you are already logged into your mysql console using say mysql -u -p replace with your username replace with your database You can use the following command to generate an csv of pretty much any SQL....

I encountered some interesting issues when pulling out CSV from my MySQL databases. The core issue was the csv generated was not seemingly compatible with the various spreadsheet readers in Windows. After having a closer look at the file, it turns out to be an encoding issue clearly. As the database was Latin1 encoded, the carriage return was handled as r [shows up as ^M on VI] in some text blobs....

One of my recent experiments with myself has lead me to the conclusion that actual objective work done is not as important as perception management. On the contrary, people who do perception management get some work done sometimes. This recent run had enough data points for me to validate my own skills, but taught me that work has no co-relation with the final perceived result. Some clear pointers when perception management drives your organization...

Just finished watching a fantastic Woody Allen movie “midnight in paris" , it is very clear that he still knows his shit! I was not expecting a lot from the movie, but ended up enjoying it with quite a few loud laughs thrown in. You had Owen Wilson, who was his usual calm self throughout and the rest really did a great job as well. The story line is about how people keep thinking the past was a better fit for them, and well it looks like people in the past also kept thinking the same....

As usual, formula 1 post the break becomes a bit more unpredictable. Its clear that some of the teams have got a whole bunch of new parts and seem to be making them work. Its interesting to see how McLaren has responded, and its clear that it will take the other frontrunners some more work to catch up with them. The exciting day ended with the following lineup for tomorrow’s race @ Monza....