SQLite Forum

Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

50 most recent forum posts by user mark

2022-06-22
18:19 Reply: Restore/backup from/to shell commands? (artifact: a3745e9449 user: mark)
10:02 Post: Restore/backup from/to shell commands? (artifact: 5f62667495 user: mark)
07:24 Reply: Tip: using sqlite3 to execute CLI one-liner queries against CSV files (artifact: ad9d1a8f3e user: mark)
2022-04-09
15:55 Reply: CSV files with multibyte character headers cannot be imported using the ".import" command (CLI). (artifact: 8e2441cbc2 user: mark)
2022-03-30
09:59 Post: CLI handling of unterminated /* comments (artifact: aefd62fcc7 user: mark)
2022-03-23
15:30 Post: Efficient Min/Max using window functions? (artifact: 364075e743 user: mark)
2022-02-11
09:25 Edit reply: A name disambiguation challenge (artifact: d96786b454 user: mark)
09:19 Reply: A name disambiguation challenge (artifact: 375b2078a3 user: mark)
2022-02-10
21:14 Edit reply: A name disambiguation challenge (artifact: a6c83b9ece user: mark)
21:00 Reply: A name disambiguation challenge (artifact: 9fdb192163 user: mark)
11:13 Reply: A name disambiguation challenge (artifact: cf1ad525bb user: mark)
09:27 Reply: Syntax checking (artifact: c7707d3a11 user: mark)
2022-02-09
15:13 Reply: Syntax checking (artifact: 0dfaaa6013 user: mark)
15:04 Reply: sqlite3 '-batch' option appears undocumented (artifact: e8f444311b user: mark)
10:46 Post: Syntax checking (artifact: 58422479a6 user: mark)
10:29 Reply: sqlite3 '-batch' option appears undocumented (artifact: 782d14242a user: mark)
2022-02-08
08:30 Reply: CLI .import command ignore/enumerate duplicate headers? (artifact: ea21644331 user: mark)
2022-02-07
11:59 Edit reply: Is there any way to get last non-null value of a column ? (artifact: 2183b56207 user: mark)
11:22 Reply: Is there any way to get last non-null value of a column ? (artifact: b82bd9f239 user: mark)
2022-02-06
16:08 Reply: CLI .import command ignore/enumerate duplicate headers? (artifact: 91ab51e65d user: mark)
2022-02-05
18:22 Reply: CLI .import command ignore/enumerate duplicate headers? (artifact: 2fe42c6f13 user: mark)
2021-11-29
08:46 Reply: sqlite CLI: .timer - should be whole transaction? (artifact: 47fd96948c user: mark)
2021-11-11
10:51 Reply: time difference between datetime value (artifact: 212a141a24 user: mark)
10:42 Reply: time difference between datetime value (artifact: 42c0821c7a user: mark)
2021-05-31
10:12 Post: UINT Collation not well linked in documentation (artifact: e8d1f87895 user: mark)
2021-05-21
07:55 Reply: Query triggers Segmentation Fault (artifact: 74307a2bf2 user: mark)
2021-05-17
10:39 Reply: Help calculating percentage in SQL (artifact: 484e7a264b user: mark)
2021-04-27
07:45 Reply: Week numbers in queries (artifact: 3ce9d0ed96 user: mark)
2021-03-31
05:55 Reply: What is the point of a lone SELECT statement in an SQLite trigger? (artifact: 7a21e8ff38 user: mark)
2021-02-23
12:04 Reply: DROP COLUMN feature with indexes (artifact: 0c3a6a63e8 user: mark)
10:59 Reply: DROP COLUMN feature with indexes (artifact: c38f475f0a user: mark)
2021-02-22
21:02 Reply: DROP COLUMN feature with indexes (artifact: 6a26ccca9a user: mark)
18:23 Reply: DROP COLUMN feature with indexes (artifact: d1f9c4a2be user: mark)
16:28 Post: DROP COLUMN feature with indexes (artifact: 90601f7c66 user: mark)
2021-02-10
13:13 Reply: SAVEPOINTS (artifact: d3cdd6f050 user: mark)
09:03 Reply: Split an Extract column (artifact: 50ea50f36e user: mark)
2021-02-08
11:48 Reply: Changes are missing after savepoint release (artifact: 26eb676d66 user: mark)
2021-02-05
08:49 Reply: Use of RETURNING clause as a subquery (artifact: 7aae5339cd user: mark)
08:36 Post: RETURNING clause and TRIGGERS (artifact: 4c4e3c6612 user: mark)
2021-02-02
10:55 Reply: SQLite3 Array? (artifact: 13178cb477 user: mark)
10:46 Reply: SQLite3 Array? (artifact: 8f34e3725d user: mark)
2021-01-31
13:23 Reply: Suggestion a new dot command (.map) (artifact: 1b143a1b11 user: mark)
2021-01-11
14:07 Reply: Syntax Error - Why? (artifact: b314a59f75 user: mark)
2021-01-05
15:36 Reply: Can not drop a table... (artifact: 3f69ebbe21 user: mark)
2021-01-04
15:46 Edit reply: Can not drop a table... (artifact: 17ed075924 user: mark)
15:40 Edit reply: Can not drop a table... (artifact: 11ad9211dc user: mark)
15:27 Reply: Can not drop a table... (artifact: 56b4d1303c user: mark)
14:50 Reply: Can not drop a table... (artifact: c476ce393a user: mark)
11:55 Post: Can not drop a table... (artifact: e7cb140bd9 user: mark)
2020-12-11
15:50 Reply: SQLite with Perl / DBI database file not updated (artifact: d02fb5e54a user: mark)