It is the first time I am going to write something serious after registering this domain. Probably I was too lazy to blog or I was working hard that I had no time to write blogs.
Any way I have decided to break the silence
Today I came across a problem where I had to add a new value to an enum column in a table with a few million rows. The traditional method of getting that done will take ages to finish and I could not afford to have a such a long window. Fortunately for me I was dealing with a MyISAM table and I had a dirty trick in mind ]:< .
I will list out a small example showing how I did it:
Suppose my table is
create table a( id int,
and I want add a new choice ‘ Don’t care’ what I will do is , I will create a new table …[Read more]