me.
>-Original Message-
>From: sqlite-users [mailto:sqlite-users-
>boun...@mailinglists.sqlite.org] On Behalf Of Wout Mertens
>Sent: Saturday, 9 June, 2018 06:22
>To: SQLite mailing list
>Subject: Re: [sqlite] Selecting multiple similar columnname.
>
>So the sate
So the satellites don't get leapsecond updates? I don't understand why it
can't just be an epoch…
On Sat, Jun 9, 2018, 8:39 AM Stephan Buchert wrote:
> To take care of the leap seconds every ~1.5 years or so, you need a day
> segmented time stamp and a three column primary key:
>
> CREATE TABLE
I forgot to add, if you do change the schema as advised, the query you
wanted will become the very easy:
SELECT SatNum FROM SatLog WHERE SNR > 30;
Which will return one or more satellites as rows, or you can do as
Gunter suggested:
SELECT group_concat(SatNum, '; ') FROM SatLog WHERE SNR >
On 2018/06/08 12:52 PM, Mukesh Kumar wrote:
Hi Ryan,
Thanks for the advice.
I cant share the exact Schema, however i can give an idea.
I am trying to store GNSS satellite info, which is streaming every second.
My Primary Key is the Timestamp at which i have got the information.. And
other
Why don't you store the values in a different table consisting only of the
fields "satellite id/number", and "strength", and a link to the appropriate row
in the source table (the one that contains the timestamp) ?
- Original Message -
From: Mukesh Kumar
To: SQLite mailing list
Sent:
Hi Ryan,
Thanks for the advice.
I cant share the exact Schema, however i can give an idea.
I am trying to store GNSS satellite info, which is streaming every second.
My Primary Key is the Timestamp at which i have got the information.. And
other columns in the table are the satellite information
On 2018/06/07 6:11 PM, mukeshkb4u wrote:
Hi All,
I have a table with multiple similar column names, like
abc_1,abc_2,abc_3...
Is there a way i can do a select on only these columns in a table, without
specifiying the full column list?
Can i use a regular expression in selecting column
On 7 Jun 2018, at 5:11pm, mukeshkb4u wrote:
> I have a table with multiple similar column names, like
> abc_1,abc_2,abc_3...
>
> Is there a way i can do a select on only these columns in a table, without
> specifiying the full column list?
> Can i use a regular expression in selecting
8 matches
Mail list logo