haxiaowei

摘要： Using Network Service DiscoveryCreating P2P Connections with Wi-FiUsing Wi-Fi P2P for Service DiscoveryUsing Network Service Discovery来源：http://develo... 阅读全文

摘要： 17.更新和删除数据更新： update table set columns = ‘value’ where ...mysql> update pw_price set price=10000 where uid=6;Query OK, 1 row affected (0.03 sec)Rows m... 阅读全文

摘要： 16 插入 insert into table values（）mysql> insert into pw_price values (5,5000,'cai');Query OK, 1 row affected (0.03 sec)mysql> select * from pw_price;\+-... 阅读全文

摘要： 15.组合查询 unionmysql> select uid,first_name,price from pw_price where uid >2 union select uid,first_name,price from pw_price where price>=1000;+-----+--... 阅读全文

摘要： 阅读：http://blog.csdn.net/kesenhoo/article/details/7390519http://developer.android.com/training/efficient-downloads/efficient-network-access.htmlOptimiz... 阅读全文

摘要： 14.高级联结表 使用别名mysql> select uid as u,name as n,msg as m from pw_luck;+----+-----------+------+| u | n | m |+----+-----------+------+| 0 |... 阅读全文

摘要： 12.子查询 子查询进行过滤mysql> select msg from pw_luck where name = 'wang5' -> ;+------+| msg |+------+| 1001 || 1000 || 1000 || 100 || 100 |+------+5 ro... 阅读全文

摘要： 具体参考：http://www.blogjava.net/qileilove/archive/2014/05/23/414005.htmlhttp://liuzhichao.com/p/1664.html实例：1.普通执行语句插入 37000ms +2.SQLiteStatement 插入 340... 阅读全文

摘要： 10.汇总数据 聚集函数 avg平均值，count行数，max最大值，min最小值，sum之和mysql> select msg,avg(msg) from pw_luck;+-----+----------+| msg | avg(msg) |+-----+----------+| 100 | ... 阅读全文

摘要： 9.数据处理函数 文本处理：Upper 大写mysql> select uid,name,msg, Upper(name) as UpperName from pw_luck;+-----+-----------+------+-----------+| uid | name | msg... 阅读全文