多列上的Sqlite主键

What is the syntax for specifying a primary key on more than 1 column in SQLITE ?

推荐答案

根据文档，这是

CREATE TABLE something (
  column1, 
  column2, 
  column3, 
  PRIMARY KEY (column1, column2)
);