I ran the following 2 commands:
create table tests (id INTEGER PRIMARY KEY, name TEXT UNIQUE);
> insert into tests values ('test 1');
>
and got the following error:
Error: table tests has 2 columns but 1 values were supplied
>
Since the id column is an alias for the rowid, shouldn't I be able to not
supply it?
--
˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
