Re: [sqlite] 2 columns as primary key?

create table tablename =
(
=A0=A0=A0=A0=A0=A0=A0 colname1 coltype,
=A0=A0=A0=A0=A0=A0=A0 colname2 coltype,
=A0=A0=A0=A0=A0=A0=A0 colname3 coltype,
=A0=A0=A0=A0=A0=A0=A0 PRIMARY KEY(colname1 asc, colname2 asc)
)
--- On Fri, 5/29/09, Pavel Ivanov wrote:
From: Pavel Ivanov
Subject: Re: [sqlite] 2 columns as primary key?
To: "General Discussion of SQLite Database"
Date: Friday, May 29, 2009, 10:54 PM
What create table statement did you use?
Pavel
2009/5/29 "Andr=E9s G. Aragoneses" :
> I just tried to create a primary key with 2 columns and got this error:
>
> "sqlite error" "table X has more than one primary key"
>
>
> Doesn't SQLite support this?? :o
>
> =A0 =A0 =A0 =A0Andres
>
> --
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users