Does a row get relocated if a column with NULL is updated with a value

[HenryMonster]

Hi All,

Does anyone know the answer to this:

say there is a nullable column in a table;
the column type is DAYTIME; there is a record
sitting in the table where this column is NULL;
now we update the record changing just this
particular column giving it some not-null value;

question: will mySql relocate this record inside the
table thus leaving a hole or it will use the original
record space ?


Thank you in advance !

Henry M.

 

[ToeShot]

It will update your original record leving it intact except your updated column. Dave
ToeShot@Hotmail.com
Today Is Tomorrows Yesterday. So Why Wait