MySQL contd: Tables

So...here we are. I had said "tomorrow", but 3 days have passed since my last mysql post.

Databases basically consist of tables. Tables are by themselves just rows and columns but can be interpreted as whatever we want. Generally, columns specify various attributes or qualities of a particular class and rows are just records (or instances) of that class, each one having specific values for each of the attributes including NULL.

Recent Insti Exploits

I. Welcome Srinivasa:
In an attempt to buy a new bicycle, I along with my friend Sagar trod along the narrow but thickly congested streets of Velachery. After being utterly disappointed by the high price mentioned by the shopkeeper for a Photon cycle (Rs. 3600), we decided to make the evening more enjoyable.

Using emacs-jabber

A couple of days back, my friend Pradeep told me how to set up gtalk inside emacs using emacs-jabber. I am going to just repeat all those instructions as well as tell some of the things that I discovered.
Note: I don't know whether the following works for windows.

About shortening links

I was always amazed by the "short" links that people used in their tweets. So I searched around and I found this interesting website.

On bit.ly, you can shorten your long links and then share them. This is especially useful on twitter since you have only 140 characters to blabber.


Another famous website which does that is tinyurl.com. Although both work fine, I think bit.ly is more miserly when it comes to number of characters in the url.
Later.

Purpose of this blog

My friend prateek read the first blog entry and made some remarks. I thank him for doing so. That motivated me to write the purpose behind creating this blog.

In this blog, I am going to write what I understand from the various things that I do in my day-to-day life; although I'll post on a variety of subjects, nonetheless the emphasis will be on academics because I want to see how much I study during a certain period of time and how much time I end up wasting in the same period.

Apart from that, I want to say that this blog is not a tutorial; it is mostly for my own understanding and future reference. Nonetheless, junta can follow it and understand the topics with a bit of efforts on their side as well.

Having said that, the most important thing is: I'll post what comes to my mind...:P

By the way, the previous MySQL stuff (and whatever is about to come) was kulted from here.

Acads this Weekend...

Okay. So, recently I have been reading about MySQL, where SQL stands for Structured Query Language, and MySQL is just one of the many versions of SQL. Although the different versions have their own specifications and special features, since SQL is ANSI standardized, there are a set of command that run on all the versions. Here is a overview of what I studied: