Re: not null values

2005-08-29 Thread Michael Stassen
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 databaseplease advise create table user_d

RE: not null values

2005-08-29 Thread Sujay Koduri
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@list