insert problem with not null columns

[Mazen Elsayed]

Dear Friends;

I am new to mysql, and I created a table named "test", with 3 columns (id"PK", firstName, lastName), all of them not null.

the problem comes when I execute the following sql statement;

INSERT INTO test (id,firstName) VALUES (4,'steven');

the record will be accepted, and there is no value in the column "lastName", even I put that as not null. How can the mySQL can accept this query, what is the value that inserted into "lastName" columns ??

regards
Mazen Elsayed