hi.

i need to put some fields as required in an mysql database. the use of keyword "not null" doesnt help.
my table is as follows :

ID integer(4) not null primary key
last_name varchar(25) not null
first_name varchar(25) not null
email varchar(25)

but when excute

insert into candidates( ID,last_name,email ) values (4,'watever','some@somewhere.com')

it works. i dun want it to accpet insertions wout first name.
is there anyway to implement this on back end?
pls dun suggest java script on front end.
i dun wanna leave any anomalies on the backend.