sqllite讲述.doc

? Sqlite的基本日常SQL操作语句汇总? 嵌入式数据库Sqlite的基本sql使用汇总，使用测试起来，与关系型数据库mysql在语法上有很多的相似之处，先准备测试数据： CREATE TABLE COMPANY(ID INT NOT NULL, NAME VARCHAR(20),AGE INT,ADDRESS VARCHAR(20),SALARY DECIMAL(7,2)); INSERT INTO COMPANY VALUES(1,Paul,32,California,20000); INSERT INTO COMPANY VALUES(2,Allen,25,Texas,15000); INSERT INTO COMPANY VALUES(3,Teddy,23,Norway,20000); INSERT INTO COMPANY VALUES(4,Mark,25,Rich-Mond,65000); INSERT INTO COMPANY VALUES(5,David,27,Texas,85000); INSERT INTO COMPANY VALUES(6,Kim,22,South-Hall,45000); INSERT INTO COMPANY VALUES(7,James,24,NULL,10000); INSERT INTO COMPANY VALUE