SQLiteManager中SQL语句

SQLiteManager可以手动操作创建table

CREATE TABLE student ("St_id" integer NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,"St_name" text NOT NULL)CREATE TABLE student2 (sid integer PRIMARY KEY AUTOINCREMENT,sname text,sage integer NOT NULL,"St_id" integer NOT NULL DEFAULT 1)

然后可以在SQL输入台验证sql语句

INSERT INTO student (St_id,St_name) VALUES(1,"ZJK")INSERT INTO student (St_id,St_name) VALUES (2,'gl')DELETE  FROM student2DROP TABLE student2select St_name from  studentselect * from studentcreate table student2("sid" integer primary key autoincrement unique,"stname"  text)select distinct St_name from student select * from student where St_id=1select * from student where St_id>2select * from student where St_name like 'jake%'select * from student where St_name between 'gl' and 'gm'select * from student where St_name <> 'gl'select * from student where St_id between 2 and 5 and St_name like 'ja%'select * from student where St_id=4 and St_name='jake'select * from student where St_id=4 or St_name='jake'select * from student where  (St_id=4  or St_id=7) and St_name='jake'select * from student order by St_id descselect sname,sage from student2 order by sname asc,sage descupdate student2 set sname='gooooo' where sname='go'update student2 set sid=10,sname='jake_go',sage=10 where sid=6delete from student2 where sid=10select *  from student2 where sname in('jake','gl')select *  from student2 where sname not between 'gl' and 'gl_jk'select *  from student2 as stselect st.sname as name from student2 as st update student2 set St_id=2 where sid=2select * from student,student2 where student.St_id=student2.St_idselect * from student2 inner join student on student.St_id=student2.St_id order by sageselect * from student3 join  student on student3.St_id=student.St_idselect * from student left join student2 on student.St_id=student2.St_id order by sageselect sname  from student3 union all select sname from student2select sname  into student_backup from student2 inner join student on student.St_id=student2.St_id select * into student_backup from studentcreate table student4(sid int,sname varchar(200),sage int)

http://www.w3school.com.cn/sql/sql_primarykey.asp