I'm in the middle of a project development, and I'm frustrated with this problem.
Im running XAMPP under Ubuntu 10.04 (Lucid Lynx)
mySQL version : Ver 14.14 Distribution 5.1.41
The problem is that, mySQL is accepting null values even if the field is declared with
the NOT NULL constraint.
CREATE TABLE `STUDENT` ( name VARCHAR(255) NOT NULL, age INT ); INSERT INTO `STUDENT` (age) VALUES (19);
In the query above. mySQL still accepts the data, even if I do not indicate any value for
the name column. Is there something wrong? Do I need to configure something in mySQL?
I really need help!