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

Flatten nested javascript array

Find longest palindrom from sequence of characters

Implement Queue Using two Stacks – JavaScript algorithm

find longest word in the sentence

String Ordered Permutation Algorithm Problem

Find the first occurence of number in the sorted array

Find K Complementary numbers from array Java implementation

Get maximum occurring character

Java solution for checking anagram strings – tell if phrases are anagrams

Kadane’s algorithm in C – Dynamic Programming

Leave a Reply

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

*
*