Results 1 to 3 of 3
Thread: Default in table blank?
May 30, 2009, 18:45 #1
Default in table blank?
So I have a table called "member." In it, there are 6 columns: Field, Type, Null, Key, Default, and Extra. In this table, the fields are "id", "username", and "password."
I understand what all of it is with the exception of column "Default." When I created the fields, the command I used for username and password is the following:
create table member( id int(4) not null auto_increment primary key, username varchar(65) not null default '', password varchar(65) not null default '', );
May 30, 2009, 19:51 #2
- Join Date
- Jul 2006
- Augusta, Georgia, United States
- 17 Post(s)
- 5 Thread(s)
I wouldn't recommend allowing default values for the username and password. Seems as if those would be necessary. Default simply means that if a value for the field isn't supplied in the insert statement that the value will default to that value. In this case the value would default to a empty string.
May 30, 2009, 21:40 #3