Re: [sqlite] Inserting the same column multiple times

On Sun, Apr 14, 2019 at 1:16 AM Luuk wrote: > > > Because, i do think, that it would never be possible to specify more > than the number of columns in an insert statement? > > The original issue was with some java/android sqlite binding that has a method that builds an insert statement on the

Re: [sqlite] Inserting the same column multiple times

On 14-4-2019 09:36, Shawn Wagner wrote: Discovered this tonight answering a question on stack overflow: sqlite> create table foo(a, b); sqlite> insert into foo(a,b,a,b) values(1,2,3,4); sqlite> select * from foo; a b -- -- 1 2 Inserting a column multiple

[sqlite] Inserting the same column multiple times

Discovered this tonight answering a question on stack overflow: sqlite> create table foo(a, b); sqlite> insert into foo(a,b,a,b) values(1,2,3,4); sqlite> select * from foo; a b -- -- 1 2 Inserting a column multiple times only uses the first corresponding