icicibank.com -- Make online banking a nightmare

icicibank.com --> Unless i am forced to use this site for all my monetary transactions, i must not have even looked at this site. This is undoubtedly the worse internet banking site. Whenever you try to do a transaction, more often than not, it will be in maintainance mode. In general, maintainance will be done once in a while. Incase of icicibank.com, it is completely the opposite.

In their quest to provide the best service, they are keeping the site under maintainance 24x7. :))) . Guys, agreed, you are the best one in town. please come out of the maintainance mode now atleast.. :))

Customers --> Don't only think of the sops they provide. It also matters how well they provide the services to you. And w/o any doubt, icicibank response to user queries is a complete mess. You have to wait indefinitely for your call to get transferred to the right department. God knows, whether it gets transferred finally or not. You have to be a really lucky person to get your query answered.

Adding to all these, icici also holds the record for loosing the crictical DMAT documents in the MUMBAI rain waters last year. Great!! i am hearing the applause too :) .. And people are asked to fill their application forms again.. :) This explains the carelessness of these people towards customers.

Summary --> ICICI service sucks, icicibank.com is hopeless, icicidirect may get drowned in rain waters sometime. Never choose icici as your salary account.

Sequences in MySQL

Auto_increment serves as a parallel to Sequences in MySQL.
But auto_increment has some limitations compared to its counterpart in Oracle.

• AUTO_INCREMENT is limited to one column per table
• AUTO_INCREMENT must be assigned to a specific table.column (not allowing multi table use)
• AUTO_INCREMENT is INSERTed as a not specified column, or a value of NULL

Even if a row is deleted, the sequence wont be reset to its previous value.

Prior Connect in MySQL

MySQL used to support CONNECT BY PRIOR in its previous version(s). But due to some of the buggy code they have found in recursion and its associated modules, they have turned off this in the new versions.

The work arounds for this problem can be found at this place.
http://forums.mysql.com/read.php?10,32818,32818#msg-32818
http://jan.kneschke.de/projects/mysql/sp/

A very good theoritical explanation for the same can be found at
http://www.intelligententerprise.com/001020/celko.jhtml?_requestid=697912