Android ---sql语句

最新推荐文章于 2020-08-20 11:25:30 发布

转载最新推荐文章于 2020-08-20 11:25:30 发布 · 884 阅读

文章标签：

#sql

数据存储专栏收录该内容

8 篇文章

订阅专栏

本文提供了SQLite数据库的基本操作指导，包括创建数据库、表结构定义、增删改查等SQL语句示例，适合初学者快速上手。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

具体应用过的:
01)删除所有的数据

 执行sql语句db.execSQL("delete from table");
     调用delete方法db.delete(table,null,null);

02)删除id>20的所有数据

 String sql = "delete from " + mDatabaseHelper.DATABASENAME + " where id in (select id from " + mDatabaseHelper.DATABASENAME +  " where id>20);";
     mDb.execSQL(sql);

03)创建数据库

mSQLiteDatabase = this.openOrCreateDatabase("kingnewTest", MODE_PRIVATE, null);
mSQLiteDatabase.execSQL("CREATE TABLE if not exists wheelcity ("
        + "regionid Integer," + "higherid Integer,"
        + "cityname varchar(255)," + "lvl Integer," + "thelast boolean"
        + ");");
cursor = mSQLiteDatabase.rawQuery(
        "select count(*) from wheelcity", null);

cursor = mSQLiteDatabase.rawQuery(
            "select count(*) from wheelcity", null);
cursor.moveToNext();

"CREATE TABLE if not exists publicGoods ("
+ "goodsId varchar(255)," + "goodsName varchar(255),"
+ "primaryUnit varchar(255)," + "subUnit varchar(255),"
+ "category varchar(255)," + "subCategory varchar(255),"
+ "companyName varchar(255)," + "provinceName varchar(255),"
+ "cityName varchar(255)"
+ ");"

几个简单的基本的sql语句
选择：select * from table1 where 范围
插入：insert into table1（field1，field2） values（value1，value2）
删除：delete from table1 where 范围
更新：update table1 set field1=value1 where 范围
查找：select * from table1 where field1 like ’%value1%’ （所有包含‘value1’这个模式的字符串）—like的语法很精妙，查资料！
排序：select * from table1 order by field1，field2 [desc]
总数：select count（*） as totalcount from table1
求和：select sum（field1） as sumvalue from table1
平均：select avg（field1） as avgvalue from table1
最大：select max（field1） as maxvalue from table1
最小：select min（field1） as minvalue from table1[separator]

参考http://blog.csdn.net/robertcpp/article/details/18261885