Select 2 random null values in a Column and replace them with a value-CodePudding

Home > Mobile > Select 2 random null values in a Column and replace them with a value

Select 2 random null values in a Column and replace them with a value

Time：02-17

my table looks kinda like this

ID  Name Username
--  ---- ----
1   A    null
2   B    charmander
3   C    null
4   D    null

I want to select 2 random null values from column Username and replace both with pikachu.

Is there a way I can to this in C#?

Appreciate any help