Re: [sqlite] Combination Key

2008-12-11 Thread Igor Tandetnik
"Rajesh Nair" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Yes I am looking for something like that. > Can you explain "create table mytable (x, y, z, primary key(x, y));" > What it will do? It will create a table with three columns and a compound primary key encompassing two of

Re: [sqlite] Combination Key

2008-12-11 Thread Rajesh Nair
Yes I am looking for something like that. Can you explain "create table mytable (x, y, z, primary key(x, y));" What it will do? can I specify x as integer and y as text ? On Thu, Dec 11, 2008 at 6:06 PM, Igor Tandetnik <[EMAIL PROTECTED]> wrote: > "Rajesh Nair" <[EMAIL PROTECTED]> > wrote in me

Re: [sqlite] Combination Key

2008-12-11 Thread Igor Tandetnik
"Rajesh Nair" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Can I define a combination-key in sqlite. If yes, how? > Sqlite is allowing me to declare more than one PRIMARY KEY. I'm not sure I understand the question, but are you perhaps looking for something like create table myt