SQLite基本语法
本文由PurpleSword(jzj1993)原创,转载请注明
原文网址 http://blog.csdn.net/jzj1993
--创建表CREATE TABLE IF NOT EXISTS table1(id INTEGER PRIMARY KEY, name text NOT NULL age INTEGER);--删除表DROP TABLE IF EXISTS table1;--增INSERT INTO table1idname) VALUES(1'Tom'--改UPDATE table1 SET name=age=5 WHERE id5--删DELETE FROM table1 WHERE id--查(单个表)SELECT count(*) FROM table1--所有列SELECT * FROM table1 WHERE id--部分列SELECT idname FROM table1 WHERE id--排序 ORDER BY hourmin ASC; ORDER BY idage DESC--查(多个表)SELECT t1.t2age FROM table1 AS t1table2 AS t2 WHERE t1= SELECT mfile martisttitleformat listtitle list_name FROM musicResource m LEFT OUTER JOIN playlistMusics p ON mfile IS NOT NULL AND mridprid LEFT OUTER JOIN playlistsInfo list ON pplaylist_idlistartist || ' - ' title '.'format f_nameFROM musicResource AS m playlistMusics AS p playlistsInfo AS list WHERE mfile IS NOT NULL AND LENGTHm)>0 AND mrid AND pSELECT DISTINCT listtitle FROM playlistsInfo AS list ORDER BY listid DESC; PRIMARY KEY
主要数据类型
其他常用数据类型
(编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |