Re: [sqlite] Help!

am...@juno.com wrote: > how to take a database in database (not structure) form--and copy and paste > it into an e-mail A database file is binary; the easiest way would be to attach it. If you want to paste it into the e-mail itself, you have to convert it to text somehow. Either create a bunch

Re: [sqlite] about upsert feature.

On 11/6/18, 畑宏和 wrote: > Hi, I have a question. > > We can use upsert after v3.24.0. > > Document says that > `INSERT INTO table-name (column-name) select-stmt upsert-clause` > But when I try this syntax, it returns syntax error. > I think we can't use ups

Re: [sqlite] about upsert feature.

Show an actual insert statement that causes an error? On Wed, Nov 7, 2018, 2:22 AM 畑宏和 Hi, I have a question. > > We can use upsert after v3.24.0. > > Document says that > `INSERT INTO table-name (column-name) select-stmt upsert-clause` > But when I try t

[sqlite] about upsert feature.

Hi, I have a question. We can use upsert after v3.24.0. Document says that `INSERT INTO table-name (column-name) select-stmt upsert-clause` But when I try this syntax, it returns syntax error. I think we can't use upsert-clause with select-stmt. Is this t