[Tutor] cant autoincrement
Lolo Lolo
losermeloser at yahoo.com
Fri Apr 26 14:45:24 CEST 2013
I'm doing a test database with sqlite and have run into some problems. in my 1st table i have an id field:
id INTERGER Primary Key
the database has a few more fields, but when i insert into it, i leave the id field empty as it should be done automatically, but sql complains with an error that i have left the field blank. If i manually put the ids in, everything works, but from my understanding this should be done automatically, aswell as it auto incrementing?
i have two tables
table1 (id, field 2, field 3, field 4)
table2 (id, field 2, field 3, FOREIGN KEY (field 3) REFERENCES table1(id))
i initially had a problem as foreign keys is not enabled by default but as my auto increment isnt working, can i just ask what does sql insert into field 3 of table2 as its a foreign key. Does it automatically insert the correspond id of table1, or is it up to me to manually insert the correct data into table2 that match with the keys on table1? I ask only because i havent had a chance to try it myself as i still have a problem with the keys, and strangely enough if i put random text into the foreign key of table 2 that didnt reference any ids on table1, sqlite still inserts them with no errors when they clearly ignore the instructions given.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/tutor/attachments/20130426/f5d5a549/attachment.html>
More information about the Tutor
mailing list