Ah, yes they both work and tell me the indexed fields.
Saves me some work parsing this out from the table create SQL.
Thanks for that.
RBS
On Thu, Dec 10, 2015 at 10:19 AM, Simon Slavin wrote:
>
> On 10 Dec 2015, at 10:17am, Bart Smissaert
> wrote:
>
> > This will show in sqlite_master like
On 10 Dec 2015, at 10:17am, Bart Smissaert wrote:
> This will show in sqlite_master like this:
>
> type name tbl_name rootpage sql
> ---
> index sqlite_autoindex_dataset_1 dataset 717
>
015 08:01
> > To: 'SQLite mailing list'
> > Subject: [sqlite] Making data unique
> >
> > Hi,
> > I have a table that consists of 3 elements:
> > ID - integer
> > Date/time - integer
> > Data - integer
> >
On Behalf Of
> Andrew Stewart
> Sent: Monday, 7 December, 2015 08:01
> To: 'SQLite mailing list'
> Subject: [sqlite] Making data unique
>
> Hi,
> I have a table that consists of 3 elements:
> ID - integer
> Date/time - integer
> Data - integer
>
On Behalf Of Andrew Stewart
> Sent: Monday, 7 December, 2015 08:01
> To: 'SQLite mailing list'
> Subject: [sqlite] Making data unique
>
> Hi,
> I have a table that consists of 3 elements:
> ID - integer
> Date/time - integer
> Data - integer
>
To: SQLite mailing list
Subject: Re: [sqlite] Making data unique
When you are about to insert into the table and find that ID & Date/time are
identical to another record, but the data is different, do you want to
overwrite, or not? Do you want an error?
Adam
On Mon, Dec 7, 2015 at 10:01 AM, An
Hi,
I have a table that consists of 3 elements:
ID - integer
Date/time - integer
Data - integer
A single ID can exist multiple times.
A single Date/time can exist multiple times.
An ID & Date/time combination is unique.
When you are about to insert into the table and find that ID &
Date/time are identical to another record, but the data is different,
do you want to overwrite, or not? Do you want an error?
Adam
On Mon, Dec 7, 2015 at 10:01 AM, Andrew Stewart
wrote:
> Hi,
> I have a table that
8 matches
Mail list logo
