Just wondering if there is a way of inserting tuples into a table without specifying the primary key id.
insert into myTable (username, password) values (value1, value2);
Ok. When I use the above mentioned statement, it complains about duplicate keys. Anyone know why? shouldn't the key be generated automatically?