Re: [sqlite] Remove row to insert new one on a full database

Stop On Fri, Apr 5, 2019, 11:31 AM James K. Lowden wrote: > On Fri, 5 Apr 2019 15:45:10 +0300 > Arthur Blondel wrote: > > > The data is always the same. That's why removing one row should be > > enough to insert a new one. > > My problem is that some times I need to remove many rows to add one

Re: [sqlite] Problem with clause "where X in (...)"

Get me of this list On Wed, Feb 13, 2019, 8:11 AM David Raymond Here's the page with the limits for what you can give SQLite > https://www.sqlite.org/limits.html > > Depending on what your statement ended up looking like that could be the > "Maximum Length of an SQL Statement" of 1,000,000 or

Re: [sqlite] Checking differences in tables

Remove me On Wed, Feb 13, 2019, 12:54 PM Jose Isaias Cabrera > James K. Lowden, on Tuesday, February 12, 2019 11:39 AM, wrote... > >On Tue, 12 Feb 2019 15:05:29 + > >Jose Isaias Cabrera wrote: > > > >> >SELECT * From t WHERE datestamp = "20190208" > >> > >> Ok, Simon, I'll bite; :-)