浣跨敤adb鎿嶄綔鏁版嵁搴?/span>

#聽sqlite3 notes.db聽聽聽聽聽//鎵撳紑notes.db鏁版嵁搴撳鏋滄病鏈夊垯鍒涘缓notes.db锛屽苟杩涘叆sqlite鎻愮ず绗?/span>

sqlite>聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽//鍦ㄦ鎻愮ず绗︿笅杈撳叆浠ヤ笅SQL鍛戒护鎿嶄綔鏁版嵁搴撱€傜劧鍚庡彲浠ュ啓鏍囧噯

聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽 //sql璇彞浠ュ垎鍙风粨灏俱€備篃鍙互鐢?help鏌ョ湅sqlite鐨勫懡浠わ紝姝ゅ懡浠や笉聽

聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽 //鐢ㄥ垎鍙风粨灏俱€?/span>

聽

create table stu 聽 聽 聽 聽 聽 聽 聽 聽 聽聽//鍒涘缓琛?/span>

(s_id integer primary key,

s_name text not null,

score integer);

select * from table_name; 聽 聽 聽 聽 聽 聽 //鏌ヨ琛ㄨ褰暵?/span>

insert into stu values(9,'alex',80); 聽 聽//鎻掑叆璁板綍

update stu set score=score+5 where s_id=9; 聽//淇敼璁板綍

delete from stu; 聽 聽//鍒犻櫎鎵€鏈夎褰?/span>

drop table stu; 聽 聽聽//鍒犻櫎琛?/span>

聽

聽

鍙娇鐢ㄥ涓嬪懡浠ゅ疄鐜扮浉搴旀搷浣滐細

.databases聽聽聽聽聽聽聽鍒楀嚭褰撴暟鎹簱淇℃伅

.tables聽聽聽聽聽聽聽聽聽聽聽聽鍒楀嚭褰撳墠鏁版嵁搴撲笅鎵€鏈夎〃淇℃伅

.schema聽聽聽聽聽聽聽聽聽聽鍒楀嚭褰撳墠鏁版嵁搴撲腑鎵€鏈夎〃鐨勭粨鏋勪俊鎭?/span>

.exit聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽閫€鍑簊qlite

聽