create table tablename ( colname1 coltype, colname2 coltype, colname3 coltype, PRIMARY KEY(colname1 asc, colname2 asc) )
--- On Fri, 5/29/09, Pavel Ivanov <paiva...@gmail.com> wrote: From: Pavel Ivanov <paiva...@gmail.com> Subject: Re: [sqlite] 2 columns as primary key? To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Date: Friday, May 29, 2009, 10:54 PM What create table statement did you use? Pavel 2009/5/29 "Andrés G. Aragoneses" <kno...@gmail.com>: > 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 > > Andres > > -- > > _______________________________________________ > 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