Hi guys,
I am trying to work out how MYSQL deals with NULL values.
When a new column is inserted on a table already populated with records (40,000 in my case), and I specify it as NOT NULL, I can insert values without any issues. I was expecting some kind of DB errors to throw up.
This is when adding new records from both PhpMyAdmin & the PHP applications.
Does MYSQL have any utility to handle these cases? Like when a column is specified as Varchar it puts in '' or when its of type INT it puts in 0.
Thanks.