Re: [sqlite] primary, secondary keys

2005-09-30 Thread David M. Cook
On Fri, Sep 30, 2005 at 10:55:07AM -0400, Mark Wyszomierski wrote: > Does sqlite allow multiple keys? When I created a table I did: > CREATE TABLE test (name, address, fav_color, primary key(name, address)) I usually use UNIQUE, though, for "business keys", and reserve PRIMARY KEY for the auto

Re: [sqlite] primary, secondary keys

2005-09-30 Thread Mark Wyszomierski
Thanks Dennis On 9/30/05, Dennis Cote <[EMAIL PROTECTED]> wrote: > > Mark Wyszomierski wrote: > > >Hi all, > > Does sqlite allow multiple keys? When I created a table I did: > > CREATE TABLE test (name, address, fav_color, primary key(name, address)) > > Is that valid? I would like to not have any

Re: [sqlite] primary, secondary keys

2005-09-30 Thread Dennis Cote
Mark Wyszomierski wrote: Hi all, Does sqlite allow multiple keys? When I created a table I did: CREATE TABLE test (name, address, fav_color, primary key(name, address)) Is that valid? I would like to not have any duplicate name + address entries. There was no error reported but later I tried mo

[sqlite] primary, secondary keys

2005-09-30 Thread Mark Wyszomierski
Hi all, Does sqlite allow multiple keys? When I created a table I did: CREATE TABLE test (name, address, fav_color, primary key(name, address)) Is that valid? I would like to not have any duplicate name + address entries. There was no error reported but later I tried modifying the table in SQLi