Can anyone see why this isn't working?
I created the table as such:
Code:
create table members
(
member_id int not null, fname varchar(32) not null, lname varchar(32) not null,
address varchar(255) not null, phone varchar(10) not null, bond int not null DEFAULT 50,
primary key (member_id)
)
The important part is "bond int not null DEFAULT 50"
Now, that part works, at least it creates the table, however, if my understanding is right (and apparently it's not) I should be able to do
Code:
insert into members values (1, 'firstname', 'lastname', 'address', '12345')
leaving out the last part, as it should default to 50.
Unfortunately, I keep getting "Insert Error: Column name or number of supplied values does not match table definition."
Can anyone help?