Tag Archives: adding a new field in mysql

“ISnull” field in Mysql database table showing as Zero for a single record. Why?

Present scenario:: In an already existing table we added a new field with data type tinyint with default as null Age- varchar-250 name-varchar-250 testid-tinyint-default-null-yes (newly added field) After creating the new field entire table data with testid as ‘NULL’ value. and once i did update on a particular record through query testid updated to ‘0’… Read More »