SQLite Forum

Timeline
Login

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

50 most recent forum posts by user mark

2024-04-22
08:32 Reply: Subquery / Aggregate function in Returning Clause (artifact: 2c83569ce8 user: mark)
08:11 Reply: Subquery / Aggregate function in Returning Clause (artifact: a89d7383c8 user: mark)
2024-04-21
14:15 Edit reply: Subquery / Aggregate function in Returning Clause (artifact: 453d19eccf user: mark)
13:58 Reply: Subquery / Aggregate function in Returning Clause (artifact: 641254a139 user: mark)
13:49 Reply: Subquery / Aggregate function in Returning Clause (artifact: c3c7fafc88 user: mark)
2024-03-20
09:24 Reply: Pack (artifact: e6d3c17f9f user: mark)
2024-03-05
18:37 Reply: Index doesn't have expected performance benefit (artifact: 3017e29932 user: mark)
10:26 Reply: Fiddle Mandelbrot formatting (artifact: d1a0ee43dd user: mark)
10:17 Edit reply: Fiddle Mandelbrot formatting (artifact: c64c365971 user: mark)
10:17 Reply: Fiddle Mandelbrot formatting (artifact: 9a00b5999f user: mark)
08:55 Post: Fiddle Mandelbrot formatting (artifact: 726cebe4aa user: mark)
2024-02-21
10:36 Reply: Feature idea: Allow date / time function modifiers to use ISO 8601 durations (artifact: b06b25b3d6 user: mark)
2024-02-18
14:24 Reply: Novice query question: trying to identify missing rows without first building all possible combinations? (artifact: 7ffb8d941b user: mark)
2024-01-29
19:53 Reply: Find name of table column that is same as rowid (artifact: 5e43c2251c user: mark)
19:39 Edit reply: Find name of table column that is same as rowid (artifact: d672c3b288 user: mark)
19:36 Reply: Find name of table column that is same as rowid (artifact: ab7d33e41e user: mark)
16:18 Reply: Find name of table column that is same as rowid (artifact: 1fd55933c5 user: mark)
16:02 Reply: Find name of table column that is same as rowid (artifact: a977f8c067 user: mark)
2024-01-15
09:34 Edit reply: Updating a field in a table with a value from another table when they have a common field - is this query correct? (artifact: 2165e89711 user: mark)
09:15 Reply: Updating a field in a table with a value from another table when they have a common field - is this query correct? (artifact: a465ac378b user: mark)
2024-01-12
11:18 Reply: sqlite .dump with CHECKS breaking (artifact: e251f579ab user: mark)
10:57 Reply: sqlite .dump with CHECKS breaking (artifact: 65152babbe user: mark)
08:44 Reply: sqlite .dump with CHECKS breaking (artifact: 5d46371e9c user: mark)
2024-01-11
10:39 Edit reply: SQL error: near "CASE": syntax error (artifact: e05e52656e user: mark)
10:37 Reply: SQL error: near "CASE": syntax error (artifact: 9a25b8a193 user: mark)
2023-12-19
08:54 Edit reply: updating columns based on geopoly_contains_point() (artifact: a74f783d34 user: mark)
08:52 Reply: updating columns based on geopoly_contains_point() (artifact: bece57fa39 user: mark)
08:42 Reply: updating columns based on geopoly_contains_point() (artifact: 78afd10d91 user: mark)
08:31 Edit reply: updating columns based on geopoly_contains_point() (artifact: 3e9282f83a user: mark)
08:16 Edit reply: updating columns based on geopoly_contains_point() (artifact: 2c6f2b36c7 user: mark)
08:09 Reply: updating columns based on geopoly_contains_point() (artifact: d73b11690e user: mark)
2023-12-17
12:37 Edit reply: updating columns based on geopoly_contains_point() (artifact: 122042fb2c user: mark)
12:36 Edit reply: updating columns based on geopoly_contains_point() (artifact: 65af11e4da user: mark)
12:31 Edit reply: updating columns based on geopoly_contains_point() (artifact: 04f6d886ae user: mark)
12:19 Reply: updating columns based on geopoly_contains_point() (artifact: d1c1eb29b8 user: mark)
2023-12-06
11:10 Reply: how to update a field on insert using a trigger (artifact: db8ebe1f26 user: mark)
2023-11-29
19:35 Reply: strange ATTACHed db behavior (artifact: 66135283b5 user: mark)
19:24 Edit reply: strange ATTACHed db behavior (artifact: e03979b0e6 user: mark)
19:23 Reply: strange ATTACHed db behavior (artifact: 686f0ef416 user: mark)
19:17 Reply: strange ATTACHed db behavior (artifact: 0ffa48c04e user: mark)
2023-11-27
11:03 Edit reply: cloning a table (artifact: b346612896 user: mark)
10:56 Reply: cloning a table (artifact: 2bc9d36cec user: mark)
10:41 Reply: FK mismatch (artifact: 6ae8c7315f user: mark)
2023-11-01
07:01 Reply: Split string into new Columns (artifact: 4531cfac0c user: mark)
2023-10-31
11:06 Reply: Split string into new Columns (artifact: d8ce7f0c23 user: mark)
10:59 Reply: Split string into new Columns (artifact: 8f50ea9c70 user: mark)
2023-10-25
09:59 Reply: SQLite version 3.44.0 now in beta (artifact: 603739e863 user: mark)
09:04 Reply: SQLite version 3.44.0 now in beta (artifact: f9c75f8a72 user: mark)
2023-10-23
09:52 Reply: UNIQUE column allowing only a single NULL value (artifact: 313b126498 user: mark)
2023-10-18
08:16 Reply: (Deleted) (artifact: 8807187722 user: mark)