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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]