Mysql Null or 0?

wxdqz

New Member
Hi,

I know there are lot of knowlegable persons around here. Need some helps.

I use mysql as database server, use PHP as script. When I load data into my database\'s table, some column should have no data (should be blank). but when I upload them into tables, those blank column became into 0.

That column's description like " ImageNum int (10)"

When I tried to update those 0 rows or column into blank or null using code like

update Image set ImageNum=" " where ImageNum=0;

my ImageNum column's data didn't altered.

Have somebody had idea or insights?

Thanks,
 
Back
Top