Hi Pravin,
The problem you are seeing here is probably related to the fact you have
some other foreign keys that rely on the user_id column, Mysql will do
everything to make your life miserable if you change the name of the
column/size of type that has other constraints depend on it - and the
Hey Ergo,
Thanks for the reply.
I wonder what will happen to the performance when trying to drop and
recreate the foreign key constraints if the table has thousands of
data(lets say 50k)?
Regards
Pravin B
On Monday, 23 July 2012 19:02:23 UTC+5:30, Ergo wrote:
Hi Pravin,
The problem
Unless we are talking millions of rows and table of size 500+mb, nothing
happens - it will be very fast,
Normally when you start running alters on your table it will get locked for
a while, but unless the table is really big you wont notice anything.
The performance of those operations depends