摘要:
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... 阅读全文