ge = age + 2;
sqlite> UPDATE people SET name = 'Eva' WHERE name='Alice';
sqlite> DELETE FROM people WHERE name = 'Bob';
sqlite> SELECT * FROM change_log;
1|2018-11-03
00:56:22|INSERT|people|1|{"id":[null,1],"created":[null,"2018-11-03
Hi,
Sorry. I have had no luck with this.
I followed the instructions here
https://www.sqlite.org/getthecode.html#clone
then built from source following the directions in README.md.
mkdir bld;# Build will occur in a sibling directory
cd bld ;# Change to the
ags: apple-osx)
01:12:06 [e0d30c1862] *MERGE* Merge fuzz test cases computed by dbfuzz2.
(user: drh)
01:04:18 [d57873337a] Improved corrupt database detection in the
relocatePage() routine of the b-tree module. (user: drh)
/Lindsay
On Fri, Nov 2, 2018 at 4:49 PM Lindsay Lawrence
wrote:
> Hi,
On Fri, Nov 2, 2018 at 10:00 AM Richard Hipp wrote:
> On 11/2/18, Lindsay Lawrence wrote:
> > Has anyone else run into this issue?
>
> I can confirm that it is an issue and that we are working on it.
> --
> D. Richard Hipp
> d...@sqlite.org
> _
Has anyone else run into this issue?
I have the following tables and trigger
- Data table
CREATE TABLE people (
id INTEGER PRIMARY KEY,
created TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
name TEXT,
age INTEGER
);
-- Change log table
CREATE TABLE change_log (
id INTEGER PRIMARY
Has anyone else run into this issue? Is there a workaround?
I have the following tables and trigger
- Data table
CREATE TABLE people (
id INTEGER PRIMARY KEY,
created TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
name TEXT,
age INTEGER
);
-- Change log table
CREATE TABLE change_log (
very
> flexible. Sqlite just does it's thing with a minimum amount of fuss and
> minimal impact on system resources, can't rave enough. :-)
>
>
> On 3 February 2017 at 18:29, Lindsay Lawrence
> wrote:
>
> > Running the sqlite3 command-line shell via cgi wor
Running the sqlite3 command-line shell via cgi works way better than you
may expect.
The command-line shell has a small footprint and works well with stdio in
batch mode.
You can run a shell script that runs an instance of the cli shell and reads
and runs a .sql file. The sql file and bash can be
I have found SQLite is uniquely suited to server-based applications of all
kinds. Wrapped in a simple custom server it is an outstandingly performant
ultra-lightweight engine that can easily service multiple clients. The
ability to spin up multiple instances of the library against the same file
is
Hi,
I am currently using sqlite3 version:
3.8.1 2013-10-17 12:57:35 c78be6d786c19073b3a6730dfe3fb1be54f5657a
I found an edge case bug in the sqlite3 shell when importing csv data with
fields containing embedded quotes, CRs and LFs:
When a field contains an embedded quote, and that embedded quot
10 matches
Mail list logo
