<p>How can I set all the 0 values to NULL in an SQL table ?</p> <p>Thanks in advance.</p>

<pre class="prettyprint"><code>update table set col = null where col = 0 </code></pre>

Set all the 0 values to NULL

update table set col = null where col = 0

141

answered Oct 05 '22 04:10

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!