Sqlite语法
id字段自增 sql="CREATE TABLE IF NOT EXISTS MusicList (id integer primary key AutoIncrement,name varchar(20),path varchar(20))"; <br>常用Select语句 desc <table> //查看表结构 select * from <table> //查询所有更 select , from table ;//查看指定列 select distinct , from table ;//非重复查询 insert into users(_id,username,password) select * from users;//复制 select username from users where username like 'S%' ;//非重名字首字母为大写S的用户 select username from users where username like '__S%'
阅读全文