<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[Little_feather的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/Little_feather</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; Little_feather]]></copyright><item><title><![CDATA[mysql 表分区]]></title><link>https://blog.youkuaiyun.com/Little_feather/article/details/70160228</link><guid>https://blog.youkuaiyun.com/Little_feather/article/details/70160228</guid><author>Little_feather</author><pubDate>Thu, 13 Apr 2017 17:31:44 +0800</pubDate><description><![CDATA[注： 1.只有mysql 5.1版本及其以上版本才支持分区，5.6版本才支持截断分区，分区原理基本和Oracle相同。
   2.只有主键才可作为分区依据 ，创建主键的代码 primary key 。
3.如果想使用主键id之外的列来作为分区的依据，可以使用复合主键
primary key (id,name)

一：范围分区
就是根据数据库表中某一字段的值的范围来划分分区，例如：
S]]></description><category></category></item><item><title><![CDATA[sql经纬度查询]]></title><link>https://blog.youkuaiyun.com/Little_feather/article/details/69668616</link><guid>https://blog.youkuaiyun.com/Little_feather/article/details/69668616</guid><author>Little_feather</author><pubDate>Sat, 08 Apr 2017 14:38:35 +0800</pubDate><description><![CDATA[查询某一坐标附近1公里内的信息



select * from parking
		where pa_examine=1 and pa_yes=1 and sqrt(
		(
		((#pa_longitude#-pa_longitude) * PI () * 12656 * cos
		(((#pa_latitude# + pa_latitude)/2) * PI
		()/180)/]]></description><category></category></item><item><title><![CDATA[极光推送]]></title><link>https://blog.youkuaiyun.com/Little_feather/article/details/69667058</link><guid>https://blog.youkuaiyun.com/Little_feather/article/details/69667058</guid><author>Little_feather</author><pubDate>Sat, 08 Apr 2017 14:06:33 +0800</pubDate><description><![CDATA[极光推送  
control层 
		//极光的key
		String appKey1 = "b9825729bd79e6dd28a11fdb";
		String masterSecret = "24cfdf2a46029ac37dc16dec";
		JPushClient jPushClient = new JPushClient(masterSecret, appKey1);]]></description><category></category></item></channel></rss>