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 student2
DROP TABLE student2
select St_name from  student
select * from student
create table student2("sid" integer primary key autoincrement unique,"stname"  text)
select distinct St_name from student 
select * from student where St_id=1
select * from student where St_id>2
select * 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 desc
select sname,sage from student2 order by sname asc,sage desc
update student2 set sname='gooooo' where sname='go'
update student2 set sid=10,sname='jake_go',sage=10 where sid=6
delete from student2 where sid=10
select *  from student2 where sname in('jake','gl')
select *  from student2 where sname not between 'gl' and 'gl_jk'
select *  from student2 as st
select st.sname as name from student2 as st 
update student2 set St_id=2 where sid=2
select * from student,student2 where student.St_id=student2.St_id
select * from student2 inner join student on student.St_id=student2.St_id order by sage
select * from student3 join  student on student3.St_id=student.St_id
select * from student left join student2 on student.St_id=student2.St_id order by sage
select sname  from student3 union all select sname from student2
select sname  into student_backup from student2 inner join student on student.St_id=student2.St_id 
select * into student_backup from student
create table student4(sid int,sname varchar(200),sage int)

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