This question already has an answer here:
- sqlite insert into table select * from 2 answers
I have database A for caching and B at the server, so I want to send a row from A to B and for that I need to generate the insert statement for already existed row in A.
below is what I want to accomplish
get insert select * from table where myId = 5;
and it should return
insert into table(myId,Col1,Col2,...) VALUES (5,'value1','value2',...);
I already had looked into this and this, that are not addressing my question. Thanks in advance!
Aucun commentaire:
Enregistrer un commentaire