如果我想指定id为主键,那么建表的语句是这样的query.exec("CREATE TABLE IF NOT EXISTS linkedApplication (id VARCHAR(20) PRIMARY KEY ," "room VARCHAR(20) NOT NULL," "name VARCHAR(20) NOT NULL)");那么我想让id和name二者作为复合主键应该如何建表呢?
...全文
1041打赏收藏
数据库建表时复合主键
如果我想指定id为主键,那么建表的语句是这样的query.exec("CREATE TABLE IF NOT EXISTS linkedApplication (id VARCHAR(20) PRIMARY KEY ," "room VARCHAR(20) NOT NULL," "name VARCHAR(20) NOT NULL)");那么我想让id和name二者作为复合主键应该如何建表呢?