>Hi,
>
>I am changing the foreign key constraint from setting the value in the foreign key to NULL (on delete) to empty string.
>
>The current syntax is
>

>on delete set NULL
>

>
>How do I change it to set to empty string? I tried the following but I get error:
>

>on delete set '' 
>

>
>What is the correct syntax? TIA

I don't think there is a way.