joshua pereira wrote:
> i want to make it so that i will have to fill in all
> the attributes in .so i put not null for all the
> attributes. Is this correct ?? when for example do
> not fill in user_name , all the other values is
> accepted and stored in the database....please advise
>
> create table user_details
> (user_id varchar(10) not null primary key,
> user_name varchar(50) not null,
> user_email varchar (30) not null,
> user_contact int not null,
> user_username varchar (20) not null,
> user_password varchar (20) not null
> );
>
> thank you...
>
Perhaps you were expecting an error? You should read
<http://dev.mysql.com/doc/mysql/en/constraint-invalid-data.html>.
Michael
