MySQL Question (not related to PHP)

[Traduim]

I'm going nuts trying to make MySQL understand I want it to put the default value in a SET field.

I have this structure:

id INT(10) NOT NULL autoincrement
fecha1 DATETIME NOT NULL 0000-00-00 00:00:00
fecha2 DATETIME NOT NULL 0000-00-00 00:00:00
procesado SET("si","no" ) NOT NULL "no"

And I want to import a CSV file where some records have the field procesado empty. I want MySQL to replace the empty values of my CSV by "no" (as the default value).

I've tried to format my CSV in 3 different ways:

1) id_value,fecha1_value,fecha2_value,
2) id_value,fecha1_value,fecha2_value,NULL
3) id_value,fecha1_value,fecha2_value,''

Unfortunately, this 3 combinations do not produce the expected result and they fill records with the field procesadoempty

Can anybody bring a bit of light over my little problem?

[bad76]

Hi
I think be enough try with 0 (but not '0' or "0"...):

"insert into table values(... '$val1', '$val2' , 0, ...)"

[drawmack]

try using the default keyword before the word no

[Traduim]

Nice try, but it does not work neither :-(

MySQL keeps inserting empty procesados

[bad76]

😃
Ok after NT, an XP :

I'm running some example, and to work you have to rewrite insert to not use values, but set. This:

insert into distributor set fetcha1='some data', fetcha2='some data'

work fine and put the default "no" in procesado...