<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[a799009094的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/a799009094</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; a799009094]]></copyright><item><title><![CDATA[php mongodb 链接失败,提示Authentication failed on database...[坑]]]></title><link>https://blog.youkuaiyun.com/a799009094/article/details/101983470</link><guid>https://blog.youkuaiyun.com/a799009094/article/details/101983470</guid><author>a799009094</author><pubDate>Tue, 07 Jun 2016 16:10:00 +0800</pubDate><description><![CDATA[确认用户名和密码都正常，权限也已经分配都没有问题，就是链接不上，其实有可能是因为php_mongo.dll的版本问题，1.4升级到1.6就正常了

转载于:https://www.cnblogs.com/mk9007/p/5567346.html...]]></description><category></category></item><item><title><![CDATA[Javascript思学笔记(一)]]></title><link>https://blog.youkuaiyun.com/a799009094/article/details/101983469</link><guid>https://blog.youkuaiyun.com/a799009094/article/details/101983469</guid><author>a799009094</author><pubDate>Sun, 27 Jul 2014 22:55:00 +0800</pubDate><description><![CDATA[理论知识点一
一个完整的javascript实现应该由下列三个不同的部分组成1.核心(ECMAScript)2.文档对象模型(DOM)3.浏览器对象模型(BOM)
二.HTML4.01的Script有6个属性，了解一下1.async:表示应该立即下载脚本，但不应妨碍页面中的其他操作，比较下载其他资源或等待加载其他脚本.只对外部脚本文件有效2.charset:代码的字符集。大多数浏览器...]]></description><category></category></item><item><title><![CDATA[Mysql随机整数]]></title><link>https://blog.youkuaiyun.com/a799009094/article/details/101983467</link><guid>https://blog.youkuaiyun.com/a799009094/article/details/101983467</guid><author>a799009094</author><pubDate>Thu, 17 Jul 2014 16:02:00 +0800</pubDate><description><![CDATA[若要在i≤R≤j这个范围得到一个随机整数R，需要用到表达式 FLOOR(i+ RAND() * (j–i+ 1))。例如， 若要在7 到 12 的范围（包括7和12）内得到一个随机整数, 可使用以下语句：
SELECT FLOOR(7 + (RAND() * 6));

FLOOR(i+ RAND() * (j–i+ 1))

转载于:https:/...]]></description><category></category></item><item><title><![CDATA[选中文本颜色]]></title><link>https://blog.youkuaiyun.com/a799009094/article/details/101983468</link><guid>https://blog.youkuaiyun.com/a799009094/article/details/101983468</guid><author>a799009094</author><pubDate>Wed, 09 Jul 2014 08:52:00 +0800</pubDate><description><![CDATA[::selection{ background-color: #00f; color: white; }
::moz-selection{ background-color: #00f; color: white; }
::webkit-selection{ background-color: #00f; color: white; }



转载于:https://www...]]></description><category></category></item><item><title><![CDATA[趣味问答]]></title><link>https://blog.youkuaiyun.com/a799009094/article/details/101983465</link><guid>https://blog.youkuaiyun.com/a799009094/article/details/101983465</guid><author>a799009094</author><pubDate>Fri, 20 Jun 2014 17:06:00 +0800</pubDate><description><![CDATA[SELECT a.id,b.name FROM tab1 AS a LEFT JOIN tab2 AS b ON(a.id = p.id) WHERE a.id &gt; 10
以上sql返回的结果中name列也许会出现 null 的情况，那么在name字段上使用什么函数可以将出现的 null 改为一个默认值？


　ifnull(a.id,0)

&lt;?php $...]]></description><category></category></item><item><title><![CDATA[Windows UI]]></title><link>https://blog.youkuaiyun.com/a799009094/article/details/101983466</link><guid>https://blog.youkuaiyun.com/a799009094/article/details/101983466</guid><author>a799009094</author><pubDate>Thu, 29 May 2014 17:07:00 +0800</pubDate><description><![CDATA[http://www.cnblogs.com/nywd/

转载于:https://www.cnblogs.com/mk9007/p/3759564.html]]></description><category></category></item><item><title><![CDATA[ThinkPHP简易别名,自动前缀]]></title><link>https://blog.youkuaiyun.com/a799009094/article/details/101983463</link><guid>https://blog.youkuaiyun.com/a799009094/article/details/101983463</guid><author>a799009094</author><pubDate>Mon, 26 May 2014 14:32:00 +0800</pubDate><description><![CDATA[$gift_category-&gt;join('AS b /*INNER JOIN*/');

转载于:https://www.cnblogs.com/mk9007/p/3753036.html]]></description><category></category></item><item><title><![CDATA[二级菜单通过一个ID查找父级ID]]></title><link>https://blog.youkuaiyun.com/a799009094/article/details/101983464</link><guid>https://blog.youkuaiyun.com/a799009094/article/details/101983464</guid><author>a799009094</author><pubDate>Mon, 26 May 2014 14:30:00 +0800</pubDate><description><![CDATA[select `id`,`name`,`pid` AS `q_pid`,(select id  From qiyu_gift_category where id = q_pid ) as root_id from qiyu_gift_category WHERE id = 1SELECT `id` FROM `qiyu_gift_category` WHERE id = (SELEC...]]></description><category></category></item><item><title><![CDATA[wampServer 添加不同端口网站]]></title><link>https://blog.youkuaiyun.com/a799009094/article/details/101983462</link><guid>https://blog.youkuaiyun.com/a799009094/article/details/101983462</guid><author>a799009094</author><pubDate>Sun, 25 May 2014 16:21:00 +0800</pubDate><description><![CDATA[cd /d F:\wamp\bin\apache\Apache2.2.21\bin
httpd.exe -k install -n "noodle" -f "F:\wamp\bin\apache\Apache2.2.21\conf\httpd2.conf"★ control -&gt; server -&gt; noodle[server] -&gt; run!



转载于...]]></description><category></category></item><item><title><![CDATA[MYSQL 显示宽度]]></title><link>https://blog.youkuaiyun.com/a799009094/article/details/101983438</link><guid>https://blog.youkuaiyun.com/a799009094/article/details/101983438</guid><author>a799009094</author><pubDate>Sun, 25 May 2014 10:34:00 +0800</pubDate><description><![CDATA[显示宽度只用于显示，并不能限制取值范围和占用空间，例如：INT(3)会占用4个字节的存储空间，并且允许的最大值也不会是999，而是INT整型
所允许的最大值。

转载于:https://www.cnblogs.com/mk9007/p/3750850.html...]]></description><category></category></item><item><title><![CDATA[Javascript魔法代码]]></title><link>https://blog.youkuaiyun.com/a799009094/article/details/101983460</link><guid>https://blog.youkuaiyun.com/a799009094/article/details/101983460</guid><author>a799009094</author><pubDate>Sun, 25 May 2014 00:44:00 +0800</pubDate><description><![CDATA[JavaScript:R=0; x1=.1; y1=.05; x2=.25; y2=.24; x3=1.6; y3=.24; x4=300; y4=200; x5=300; y5=200; DI=document.images; DIL=DI.length; function A(){for(i=0; i-DIL; i++){DIS=DI[ i ].style; DIS.positi...]]></description><category></category></item><item><title><![CDATA[windows 2003 配置环境所需软件]]></title><link>https://blog.youkuaiyun.com/a799009094/article/details/101983459</link><guid>https://blog.youkuaiyun.com/a799009094/article/details/101983459</guid><author>a799009094</author><pubDate>Fri, 23 May 2014 14:03:00 +0800</pubDate><description><![CDATA[http://pan.baidu.com/s/1sjxztgx
配置环境麻烦,特别是下载各种软件，现在收集成一个包，方便日后使用

转载于:https://www.cnblogs.com/mk9007/p/3747587.html]]></description><category></category></item><item><title><![CDATA[一个无限级分类]]></title><link>https://blog.youkuaiyun.com/a799009094/article/details/101983457</link><guid>https://blog.youkuaiyun.com/a799009094/article/details/101983457</guid><author>a799009094</author><pubDate>Thu, 22 May 2014 21:39:00 +0800</pubDate><description><![CDATA[1 /**
 2  * 把返回的数据集转换成Tree
 3  * @param array $list 要转换的数据集
 4  * @param string $pid parent标记字段
 5  * @param string $level level标记字段
 6  * @return array
 7  */
 8 function list_to_tree(...]]></description><category></category></item><item><title><![CDATA[大数据时的运算效率问题]]></title><link>https://blog.youkuaiyun.com/a799009094/article/details/101983458</link><guid>https://blog.youkuaiyun.com/a799009094/article/details/101983458</guid><author>a799009094</author><pubDate>Thu, 22 May 2014 16:12:00 +0800</pubDate><description><![CDATA[第一步，優化字段
 原始數據導入數據時，對所有字段進行優化，儘可能地爲每個字段選用最小的字段類型 字符型字段，一般導入時默認會是nvarchar型，改爲varchar型節省一半空間。 數值型字段，如果是整數，如果最大可能數小於255，改爲tinyiny，如果最大可能數小於32768，改爲smallint，如果長度小於9位，改爲int。如果帶小數點，精度要求不是非常高的...]]></description><category></category></item><item><title><![CDATA[php 处理上百万条的数据库如何提高处理查询速度]]></title><link>https://blog.youkuaiyun.com/a799009094/article/details/101983455</link><guid>https://blog.youkuaiyun.com/a799009094/article/details/101983455</guid><author>a799009094</author><pubDate>Thu, 22 May 2014 15:53:00 +0800</pubDate><description><![CDATA[1.对查询进行优化，应尽量避免全表扫描，首先应考虑在 where 及 order by 涉及的列上建立索引。 
2.应尽量避免在 where 子句中对字段进行 null 值判断，否则将导致引擎放弃使用索引而进行全表扫描，如： select id from t where num is null 可以在num上设置默认值0，确保表中num列没有null值，然后这样查询： select i...]]></description><category></category></item><item><title><![CDATA[Mysql-基本语法]]></title><link>https://blog.youkuaiyun.com/a799009094/article/details/101983456</link><guid>https://blog.youkuaiyun.com/a799009094/article/details/101983456</guid><author>a799009094</author><pubDate>Wed, 21 May 2014 13:53:00 +0800</pubDate><description><![CDATA[摘录于:http://www.cnblogs.com/lyhabc/p/3691555.html
1.default

--sqlserver
CREATE TABLE emp
(
id INT DEFAULT(12)
)


--mysql
CREATE TABLE emp
(
id INT DEFAULT 12
)

2.AUTO

--设置自增...]]></description><category></category></item><item><title><![CDATA[javascript中的浅复制和深复制]]></title><link>https://blog.youkuaiyun.com/a799009094/article/details/101983439</link><guid>https://blog.youkuaiyun.com/a799009094/article/details/101983439</guid><author>a799009094</author><pubDate>Wed, 21 May 2014 13:42:00 +0800</pubDate><description><![CDATA[浅复制：就是把数据的地址赋值给对应变量，而没有把具体的数据复制给变量，变量会随数据值的变化而变化。
深复制：就是把数据赋值给对应的变量，从而产生一个与源数据不相干的新数据(数据地址已变化)。
浅复制不会随着存储数据地址的变化而变化，只会随着数据值的变化而变化。


实现引用类型的深度复制function clone(obj){ var o=[];  if(obj...]]></description><category></category></item><item><title><![CDATA[IIS禁用目录浏览]]></title><link>https://blog.youkuaiyun.com/a799009094/article/details/101983452</link><guid>https://blog.youkuaiyun.com/a799009094/article/details/101983452</guid><author>a799009094</author><pubDate>Wed, 21 May 2014 09:27:00 +0800</pubDate><description><![CDATA[打开IIS -&gt;选择要禁用的站点-&gt;主目录选项卡-&gt;主目录浏览去勾


Life is painting a picture, not doing a sum.生活是绘画，不是做算术。



转载于:https://www.cnblogs.com/mk9007/p/3740579.html...]]></description><category></category></item><item><title><![CDATA[Ubuntu添加Wine]]></title><link>https://blog.youkuaiyun.com/a799009094/article/details/101983440</link><guid>https://blog.youkuaiyun.com/a799009094/article/details/101983440</guid><author>a799009094</author><pubDate>Sun, 18 May 2014 23:30:00 +0800</pubDate><description><![CDATA[sudo apt-get install wine1.4



转载于:https://www.cnblogs.com/mk9007/p/3735973.html]]></description><category></category></item><item><title><![CDATA[Ubuntu删除程序命令]]></title><link>https://blog.youkuaiyun.com/a799009094/article/details/101983441</link><guid>https://blog.youkuaiyun.com/a799009094/article/details/101983441</guid><author>a799009094</author><pubDate>Sun, 18 May 2014 01:48:00 +0800</pubDate><description><![CDATA[首先sudo apt-get remove apache2

再sudo apt-get autoremove



转载于:https://www.cnblogs.com/mk9007/p/3734804.html]]></description><category></category></item></channel></rss>