Adding NULL as value to mySql database

Adding NULL as value to mySql database

Have you wondered how to update/insert NULL as value to the existing row in mysql? Too simple:

UPDATE table_name SET field_name = NULL WHERE some_criteria 

Watch! there is no any quote on the NULL part, if you do so, it would be inserted/updated as string with value “NULL”

See how you would solve these known algorithm problems

Find the first occurence of number in the sorted array

Find the pairs that makes K Complementary in the given array java solution

String Ordered Permutation Algorithm Problem

Implement Queue Using two Stacks – JavaScript algorithm

testing k complementary pairs algorithm with junit

Finding missing numbers from billion sequential number list file

Flatten nested javascript array

Find longest palindrom from sequence of characters

Check if two strings are anagrams or not

Implementing tokenizer and adding tokens to the linked list

Leave a Reply

Your email address will not be published. Required fields are marked *

*
*