SQLite Forum

How to insert duplicate rows?
Login
Why all the double quotes? They seem to be in very strange places. 

Duplicate rows certainly work:

create table dups (a text,b int);
insert into dups values ('aaa',1);
insert into dups values ('aaa',1);
insert into dups values ('aaa',1);
select * from dups;
aaa|1
aaa|1
aaa|1