MySQL for newbies and non-techies
Database analysis and management is a very huge branch of marketing. I recently met many such people. But I was amazed to see that they had no knowledge of what they were doing or how. They just knew what to do and could do that without any problem.
So, my first question fired on them was, which database are you using? He quickly replied: “MySQL”.
I quickly took a look on the persons desktop and came to know that unlike us, they had a GUI interface to access the database. My inquisitiveness lead me to learn about two very good and highly used applications:
I went further to try SQLyog. It was freely available from Google code. I tried the community edition. But it ain’t free and keeps asking you to upgrade your application!
The one thing that was amazing was that the query results were not eating up your space like on command line, where a ” select * ” could supposedly hang my computer. Moreover, the query results could be converted to text easily (very easily). Just write a query, convert result to text and copy it to your favorite text editor, email it, or just play around.
The marketing people were using it usually in email (for building reports).