创建表(以下contactinfo为表名,字段:username phone )
create table contactinfo(id integer primary key autoincrement,username text,phone text);
增加一条数据(‘zhangsan’,’150188888888’)
insert into contactinfo (username,phone)values('zhangsan','150188888888');
修改数据
update contactinfo set phone=