On 29 Feb 2020, at 8:37am, Marco Bambini wrote:
> ORDER BY (prop_tag='ios') LIMIT 1;
>
> I would like to prioritise results based on the fact that the prop_tag column
> is 'ios'.
SQLite has a conditional construction:
CASE prop_tag WHEN 'ios' THEN 0 ELSE 1 END
So do
SELECT …
ORDER BY
On Sat, Feb 29, 2020 at 1:42 PM Shawn Wagner
wrote:
> To import a csv file with headers into an existing table, you can use
> .import '| tail -n +2 yourfile.csv' yourtable
> to skip the header line.
On unix. And by shell’ing out to native tools, so not portable.
The cli ought to have something
On 2/27/20 7:03 PM, Andy KU7T wrote:
Hi,
I use a simple ALTER TABLE ADD COLUMN statement. However, when I use the Sqlite
Expert, the DDL is not reflected.
One thing to be aware of is that when SQLite adds the column, it often
doesn't format it like you'd expect. For example:
CREATE TABLE
Hi,
I want to share some thoughts and make some suggestions about the SQLite
3 command line interface (CLI) tool, especially its behaviour when
importing CSV files.
CSV files are probably even more common for data exchange than SQLite
database files. I consider it to be good practice to
To import a csv file with headers into an existing table, you can use
.import '| tail -n +2 yourfile.csv' yourtable
to skip the header line.
On Sat, Feb 29, 2020, 4:30 AM Christof Böckler wrote:
> Hi,
>
> I want to share some thoughts and make some suggestions about the SQLite
> 3 command
On Feb 27, 2020, at 11:51 PM, Christof Böckler wrote:
>
> 1. There should be no penalty for using header lines in CSV files. Thus a new
> flag -h for .import is much appreciated.
More than that, SQLite should be able to *actively use* the header when present.
For instance, given:
foo,bar,qux
> On Feb 28, 2020, at 11:49 PM, Hamish Allan wrote:
>
> Again, I may be making incorrect assumptions.
Remember the old Knuth quote about the danger of premature optimization. What’s
the size of your data set? Have you tried making a dummy database of the same
size and experimenting with
Hi all,
Is there a way to specify an ORDER BY clause by column value?
I have a table declared as:
CREATE TABLE Table1 (id INTEGER PRIMARY KEY AUTOINCREMENT, obj_id INTEGER,
prop_key TEXT, prop_value TEXT, prop_tag TEXT DEFAULT '*', UNIQUE(obj_id,
prop_key, prop_tag))
and a sample query:
SELECT prop_value FROM Table1 WHERE obj_id=10 AND prop_key='key1' AND
(prop_tag='ios' OR prop_tag='*') ORDER BY prop_tag == 'ios' DESC LIMIT 1;
You want to order by prop_tag == 'ios' in DESCENDING order. That is, the true
(1) before the false (0). The default ascending sort will sort the
9 matches
Mail list logo
