On 12 Jan 2017, at 4:06am, hfiandor <[email protected]> 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
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
