Default value - Eduardo Silva - com.mysql.lists.win32

2 messages in com.mysql.lists.win32Default value

From	Sent On	Attachments
Eduardo Silva	16 Mar 2002 21:00
Arjen Lentz	17 Mar 2002 16:24

Subject:	Default value
From:	Eduardo Silva (ecos...@hotmail.com)
Date:	03/16/2002 09:00:25 PM
List:	com.mysql.lists.win32

I'm having a little problem with MySQL : one table has a column named xID, which is a foreign key to another table. xID is a mediumint unsigned. The problem is that, whenever a line is inserted, xID receives a 0 value instead of being kept null. That is a little confusing to the operator, which has to erase the '0' manually. I have already dropped the index on xID, changed its definition from not null, etc.

Any ideas?

TIA,

Eduardo