“ISnull” field in Mysql database table showing as Zero for a single record. Why?
“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’
why it is coming like,means after updation field as 0 instead of null why this any solutions
tag:adding a new field in mysql,fields showing null value,one table
field in mysql showing as zero.
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’
why it is coming like,means after updation field as 0 instead of null why this any solutions