that I can do the search fast.
Best Regards,
Sreedhar.
-Original Message-
From: Dwight Ingersoll [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 21, 2007 11:43 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Unique ids for each record
On 8/20/07, Sreedhar.a <[EMAIL PROTECTED]>
On 8/20/07, Sreedhar.a <[EMAIL PROTECTED]> wrote:
<>
>
> I want to restrict the Artist range to 100 to 199 so that with the id
> I can make my search fast and also I knew with unique id that I need to
> search for the Artist alone.
<>
Considering the small range of data it appears you want to
Eric Bohlman wrote:
Sreedhar.a wrote:
SNIP
You need artist identifiers to be unique (you could in fact use artist
names, since copyright rules require that such names be unique). You
also need album names to be unique, but only within artist groups
(you're not going to have the *same* artis
Quoting Eric Bohlman <[EMAIL PROTECTED]>:
(you're not going to have the *same* artist release two albums with the
same name). You need track names to be unique within artists, but not
Except for weird artists like Peter Gabriel. All solo albums released
between 1977 and 1982 were self-titled
Sreedhar.a wrote:
Hi Lokesh,
Thanks for your suggestions.
My proble is assigning a unique record for each record in a table.
The database table name MUSIC.
I have 3 columns Artist Album and Tracks.
Artist1 Album1 Track1
Artist2 Album2 Track2
Artist3 Album2 Track3
I need to assign a uniqu
: Re: [sqlite] Unique ids for each record
refer *In-Memory Database: Delete rows on a Table increases the memory usage
*
More help needed or didn't understand, let me know.
On 8/17/07, Sreedhar.a <[EMAIL PROTECTED]> wrote:
>
> Thanks Marcus
>
>
>
> I am working
gt; freed only.i tried after doing vacuum also.Is there any other way to
> insert.
>
>
>
> . The rowid is also not updated after doing vacuum.Is there any
> other way to update.If I tried the same by creating a table with INTEGER
> alone at that time rowed is updating prope
fter doing vacuum.Is there any
other way to update.If I tried the same by creating a table with INTEGER
alone at that time rowed is updating properly after "Vacuum Test".
Can any one please clarify my doubts.
Best Regards,
A.Sreedhar.
-----Original Message-
From: Markus Hoenic
I assume you'd rather want three separate tables (artist, album,
track) with an autoincrementing ID field per table. Your approach
would not allow users to own more than 100 albums.
regards,
Markus
Quoting "Sreedhar.a" <[EMAIL PROTECTED]>:
Hi,
I have a table with 3 columns.
Artist Album
9 matches
Mail list logo