Re: Update NOT NULL Field with NULL!

2002-12-25 Thread Benjamin Pflugmann
Hello. On Thu 2002-12-26 at 00:09:55 +0100, [EMAIL PROTECTED] wrote: > Hi there, > > I'm using MySql 3.23.?? with Connector/J on Win32. > My Problem is that the database lets me UPDATE NOT NULL Fields with > NULL-Values. > This is not a special Java Problem! > > For example: > The Field "Name" i

Update NOT NULL Field with NULL!

2002-12-25 Thread jay_r
Hi there, I'm using MySql 3.23.?? with Connector/J on Win32. My Problem is that the database lets me UPDATE NOT NULL Fields with NULL-Values. This is not a special Java Problem! For example: The Field "Name" in tbl_Names is declared NOT NULL. UPDATE tbl_Names SET Name = NULL WHERE ID = 23; ...wo