No worries :D as long as its same naming convention all through out the whole program :)

that's for my testing only, dont mind the insert and delete :D just checked if the query works even if one city do not have ony of temp/humidity/rain

how about max_len or max_length and not maxLength? For me seeing camel-cased code means its a function :)