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:

1. Navicat

2. SQLyog

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).

Advertisements
Explore posts in the same categories: Uncategorized

Tags: , , ,

You can comment below, or link to this permanent URL from your own site.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: