Re: how insert value null in row

#1

nawfer wrote:

Quote:

if the table mysql has 4 field so:
ID int(11) NOT NULL auto_increment,
camp2 varchar(10) NOT NULL default '',
camp3 int(11) NULL default '',
camp4 varchar(10) NULL default '',
PRIMARY KEY (ID),
KEY camp3 (camp3)

why it does not make me to update camp3 and 4 with a value null or ''
do not work:
UPDATE $my_var_tabella
SET camp3 = '', camp4 = ''
WHERE ID = $my_var_number

Just guessing (never used mysql), but what would it mean to assign ''
to an int column? The definition of the table itself looks very wierd
to, what does *camp3 int(11) NULL default ''* mean?

Quote:

also writing
SET camp3 = NULL, camp4 = NULL not work
where is the error?

This should be ok

Quote:

instead if I insert some data it works:
SET camp3 = $id_number, camp4 = $name_text

not want '' or NULL, even if with CREATE TABLE I have insert in
camp3 and 4 this '' how default

I dont follow, can you provide more details?

/Lennart

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: how insert value null in row

comp.databases comp.databases

Re: how insert value null in row - 11-05-2006 , 03:58 AM