I am having MySQL table and a column of this having the AUTO_INCREMENT property. Now I want to insert ‘NULL’, ‘0’ or no value to that column. Will MySQL also generate the sequence number for those NULL or 0 or no values also?
I am doing a small project where I need to read data from a file and store into a database. But I need to eliminate null values. How can I test whether the given string is null? Please explain with an example.