欢迎投稿

今日深度:

sqlite,

sqlite,


创建有主键的表:
create table test (pkey varchar(16) primary key, value varchar(10));


创建有复合(即key由多个字段联合组成)主键的表:
create table test (pkey1 varchar(16) , pkey2 varchar(16), primary key (pkey1,pkey2));


SQLite字典表:
select * from sqlite_master;

www.htsjk.Com true http://www.htsjk.com/SQLite/11402.html NewsArticle sqlite, 创建有主键的表: create table test (pkey varchar(16) primary key, value varchar(10)); 创建有复合(即key由多个字段联合组成)主键的表: create table test (pkey1 varchar(16) , pkey2 varchar(16), primary...
评论暂时关闭