Tuesday, September 22, 2009

How to set more than one primary key in Sqlite

Sqlite could have more than one PRIMARY KEY . Do it as the following :



CREATE TABLE ex1(
a TEXT,
b VARCHAR(10),
c FLOAT,
PRIMARY KEY(b,a)
);

0 comments:

Post a Comment