On 12 Jan 2017, at 4:06am, hfiandor <hfian...@ceniai.inf.cu> wrote: > Im trying to read a .csv file and introduce in an SQLite table, using the > insert into command. > > > > In the .csv file I have not used this Id field (it was defined as integer > and autoincrease).
Specify the fields you need in the INSERT command. So instead of INSERT INTO MyTable VALUES ('a','b','c') you should do INSERT INTO MyTable (name, address, phone) VALUES ('a','b','c') If you do this, you can miss out the Id field. When you do that, SQL makes up its own values for the Id field based on the INTEGER AUTOINCREMENT you specified. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users