表不存在则创建
create table if not exists student( _id Integer primary key autoincrement , name Text , age Integer)
当表中的数据不存在则插入,存在则更新
replace into student( _id , name ,age ) VALUES ( 1,'zz7zz7zz',25)
或
insert into student(name,age) select 'zz7zz7zz',25 where not exists(select * from student where name='zz7zz7zz' and age=25)