Use the keyword 'default' to make the attributes default to the values you want.
Use some thing like this user_name varchar(50) default 'default_value' not null sujay -----Original Message----- From: joshua pereira [mailto:[EMAIL PROTECTED] Sent: Monday, August 29, 2005 5:24 PM To: mysql@lists.mysql.com Subject: not null values 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... Send instant messages to your online friends http://uk.messenger.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]