Insert null value into db

[vladefix]

Hy,
is there a way to update a column to a null value in a statement like the folowing :

Koodi [Valitse] Laajenna


$smcFunc['db_query']('', "
   UPDATE `{db_prefix}mytable`
      SET
         `name` = {string:name},
         `fk_dummy` = {int:id_dummy}
     WHERE
         `id` = {int:id}",
         array('name' => 'test', 'id_dummy' => '', 'id' => 1));

the column is a foreign key so i can't just insert 0 or -1

Thanks

[emanuele]

Probably something like:

Koodi [Valitse] Laajenna

$smcFunc['db_query']('', "
   UPDATE `{db_prefix}mytable`
      SET
         `name` = {string:name},
         `fk_dummy` = {raw:id_dummy}
     WHERE
         `id` = {int:id}",
         array('name' => 'test', 'id_dummy' => 'null', 'id' => 1));


[vladefix]

Probably something like:

Koodi [Valitse] Laajenna

$smcFunc['db_query']('', "
   UPDATE `{db_prefix}mytable`
      SET
         `name` = {string:name},
         `fk_dummy` = {raw:id_dummy}
     WHERE
         `id` = {int:id}",
         array('name' => 'test', 'id_dummy' => 'null', 'id' => 1));


that worked
thank you

[Arantor]

Btw, SMF doesn't make this easier because SMF doesn't use null itself in any column, and there is actually a performance saving at the database level if a table has no null columns.