代码改变世界

随笔分类 -  数据库

sqlite3常用指令

2012-09-22 14:29 by Freeman in Qt, 156 阅读, 收藏,
摘要： 查询"SELECT value1,value2 FROM [tablename] WHERE key1 = ?;" // 匹配单个值"SELECT value1,value2 FROM [tablename] WHERE key1 = ? and key2 = ?;" // 匹配多个值保存"SELECTcount(*)FROM [tablename] WHERE key1 = ?;" // 匹配是否存在相同的插入 // 不存在"INSERT into [tablename] (value1,value2) values(?, 阅读全文