<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href="/css/rss/beng.xsl"  media="all" ?>
<rss version="2.0">
  <channel>
    <title>Beng</title>
    <description>翟的地盘</description>
    <link>http://beng.name</link>
    <lastBuildDate>2012-05-20 11:18:27</lastBuildDate>
    <pubDate>2012-05-20 11:18:27</pubDate>
    <language>zh-cn</language>
    <copyright>版权声明</copyright>

		<item>
	      <title><![CDATA[[转]windows.event在FF和IE中区别]]></title>
	      <description><![CDATA[<p>&nbsp;来源：http://blog.csdn.net/kewei8976/article/details/7102493</p>
<blockquote>
<p><span style="color: rgb(128, 0, 128); "><em>&lt;input &nbsp;onkeydown=&quot;inputKeyDown(event);&quot;/&gt;</em></span></p>
<p><span style="color: rgb(128, 0, 128); "><em>function inputKeyDown(e){<br />
&nbsp; &nbsp; &nbsp; &nbsp;<strong> </strong><span style="color: rgb(255, 0, 0); "><strong>&nbsp;var e1 = e||window.event;</strong></span><br />
&nbsp; &nbsp; &nbsp; &nbsp; if(e1.keyCode==13){<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;search();<br />
&nbsp; &nbsp; &nbsp; &nbsp;}<br />
}</em></span></p>
</blockquote><blockquote> </blockquote>
<p><br />
一、event对象只在事件发生的过程中才有效。<br />
event的某些属性只对特定的事件有意义。比如，fromelement 和 toelement 属性只对 onmouseover 和 onmouseout 事件有意义。</p>
<p>1、window.event<br />
IE：有window.event对象<br />
FF：没有window.event对象。可以通过给函数的参数传递event对象。如onmousemove=domousemove(event)<br />
2 、鼠标当前坐标<br />
IE：：event.x和event.y。<br />
FF：event.pagex和event.pagey。<br />
通用：两者都有event.clientx和event.clienty属性。<br />
3 、鼠标当前坐标(加上滚动条滚过的距离)<br />
IE:event.offsetx和event.offsety。<br />
FF:event.layerx和event.layery。</p>
<p>4、标签的x和y的坐标位置：style.posleft 和 style.postop<br />
IE：有。<br />
FF：没有。<br />
通用：object.offsetleft 和 object.offsettop。</p>
<p>5、窗体的高度和宽度<br />
IE：document.body.offsetwidth和document.body.offsetheight。注意：此时页面一定要有body标签。<br />
FF：windows.innerwidth和windows.innerhegiht，以及document.documentelement.clientwidth和    <br />
document.documentelement.clientheight。<br />
通用：document.body.clientwidth和document.body.clientheight。<br />
<br />
6、添加事件<br />
ie：element.attachevent(&rdquo;onclick&rdquo;, func);。<br />
ff：element.addeventlistener(&rdquo;click&rdquo;, func, true)。<br />
通用：element.onclick=func。虽然都可以使用onclick事件，但是onclick和上面两种方法的效果是不一样的，      onclick只有执行一个过程，而attachevent和addeventlistener执行的是一个过程列表，也就是多个过程。例   <br />
如：element.attachevent(&rdquo;onclick&rdquo;, func1);element.attachevent(&rdquo;onclick&rdquo;, func2)这样func1和func2都会被执  <br />
行。<br />
<br />
7、标签的自定义属性<br />
ie：如果给标签div1定义了一个属性value，可以div1.value和div1[&rdquo;value&rdquo;]取得该值。<br />
ff：不能用div1.value和div1[&rdquo;value&rdquo;]取。<br />
通用：div1.getattribute(&rdquo;value&rdquo;)。<br />
<br />
8、父节点、子节点和删除节点<br />
ie：parentelement、parement.children，element.romovenode(true)。<br />
ff：parentnode、parentnode.childnodes，node.parentnode.removechild(node)。<br />
<br />
9、type：事件的类型，如onlick中的click；<br />
srcelement/target：事件源，就是发生事件的元素；<br />
button：声明被按下的鼠标键，整数，1代表左键，2代表右键，4代表中键，如果按下多个键，酒把这些值加     起来，所以3就代表左右键同时按下；（firefox中 0代表左键，1代表中间键，2代表右键）<br />
clientx/clienty：事件发生的时候，鼠标相对于浏览器窗口可视文档区域的左上角的位置；(在dom标准中，这      两个属性值都不考虑文档的滚动情况，也就是说，无论文档滚动到哪里，只???事件发生在窗口左上角，        clientx和clienty都是 0，所以在ie中，要想得到事件发生的坐标相对于文档开头的位置，要加上<br />
document.body.scrollleft和 document.body.scrolltop)<br />
offsetx,offsety/layerx,layery：事件发生的时候，鼠标相对于源元素左上角的位置；<br />
x,y/pagex,pagey：检索相对于父要素鼠标水平坐标的整数；<br />
altkey,ctrlkey,shiftkey等：返回一个布尔值；<br />
keycode：返回keydown何keyup事件发生的时候按键的代码，以及keypress 事件的unicode字符；(firefox2       不支持 event.keycode，可以用 event.which替代 )<br />
fromelement,toelement：前者是指代mouseover事件中鼠标移动过的文档元素，后者指代mouseout事件中     鼠标移动到的文档元素；<br />
cancelbubble：一个布尔属性，把它设置为true的时候，将停止事件进一步起泡到包容层次的元素；   <br />
(e.cancelbubble = true; 相当于 e.stoppropagation();)<br />
returnvalue：一个布尔属性，设置为false的时候可以组织??览器执行默认的事件动作；(e.returnvalue =       false; 相当于 e.preventdefault();)<br />
attachevent(),detachevent()/addeventlistener(),removeeventlistener：为制定dom对象事件类型注册多个事件处理函数的方法，它们有两个参数，第一个是事件类型，第二个是事件处理函数。在attachevent()事件执行的时候，this关键字指向的是window对象，而不是发生事件的那个元素；<br />
screenx、screeny：鼠标指针相对于显示器左上角的位置，如果你想打开新的窗口，这两个属性很重要；</p>
<p>二、一些说明：<br />
1、event代表事件的状态，例如触发event对象的元素、鼠标的位置及状态、按下的键等等；<br />
2、event对象只在事件发生的过程中才有效。<br />
3、firefox里的event跟ie里的不同，ie里的是全局变量，随时可用；firefox里的要用参数引导才能用，是运行时的临时变量。<br />
4、在ie/opera中是window.event，在firefox中是event；而事件的对象，在ie中是window.event.srcelement，在firefox中是event.target，opera中两者都可用。<br />
5、下面两句效果相同<br />
var evt = (evt) ? evt : ((window.event) ? window.event : null);<br />
var evt = evt || window.event; // firefox下window.event为null, ie下event为null<br />
三、ie中事件的起泡<br />
ie中事件可以沿着包容层次一点点起泡到上层，也就是说，下层的dom节点定义的事件处理函数，到了上层的节点如果还有和下层相同事件类型的事件处理函数，那么上层的事件处理函数也会执行。例如， div 标签包含了 a ，如果这两个标签都有onclick事件的处理函数，那么执行的情况就是先执行标签 a 的onclick事件处理函数，再执行 div 的事件处理函数。如果希望的事件处理函数执行完毕之后，不希望执行上层的 div 的onclick的事件处理函数了，那么就把cancelbubble设置为true即可。<br />
四、window.event<br />
(1)现有问题：<br />
使用 window.event 无法在 FF 上运行<br />
(2)解决方法：<br />
FF 的 event 只能在事件发生的现场使用，此问题暂无法解决。可以这样变通：<br />
原代码(可在IE中运行)：<br />
&lt;input type=&quot;button&quot; name=&quot;someButton&quot; value=&quot;提交&quot; onclick=&quot;javascript:gotoSubmit()&quot;/&gt;<br />
...<br />
&lt;script language=&quot;javascript&quot;&gt;<br />
function gotoSubmit() {<br />
...<br />
alert(window.event);    // use window.event<br />
...<br />
}<br />
&lt;/script&gt;<br />
新代码(可在IE和MF中运行)：<br />
&lt;input type=&quot;button&quot; name=&quot;someButton&quot; value=&quot;提交&quot; onclick=&quot;javascript:gotoSubmit(event)&quot;/&gt;<br />
...<br />
&lt;script language=&quot;javascript&quot;&gt;<br />
function gotoSubmit(evt) {<br />
evt = evt ? evt : (window.event ? window.event : null);<br />
...<br />
alert(evt);             // use evt<br />
...<br />
}<br />
&lt;/script&gt;<br />
此外，如果新代码中第一行不改，与老代码一样的话(即 gotoSubmit 调用没有给参数)，则仍然只能在IE中运行，但不会出错。所以，这种方案 tpl 部分仍与老代码兼容。</p>
<p>&nbsp;</p>]]></description>
	      <guid isPermaLink="false">beng.name/news/108</guid>
	      <link><![CDATA[http://beng.name/article/atricle-108.html]]></link>
	      <pubDate><![CDATA[2012-04-24 17:10:58]]></pubDate>
	      <author><![CDATA[翟维金]]></author>
	    </item>
		
		<item>
	      <title><![CDATA[大理游记]]></title>
	      <description><![CDATA[<p>3. 9日晴趁着周末来了趟大理，晚上从昆明坐火车出发3.10号早晨7点就到了大理，刚一出站就体验到了大理名景之一 &ldquo;下关风&rdquo;，也就是大理政府所在地的下关这个地方风很大四季如此，很冷。</p>
<p>&nbsp;下关到大理古城还有十多公里，之前看攻略说打车到那里大概要40块钱，在火车站的时候我们很幸运的遇到了一个回古城的出租车只收了我们10块钱。</p>
<p>到了古城先是吃了顿扒肉饵丝当早餐然后就去找住的地方了。</p>
<p><img alt="饵丝" width="250" height="188" title="饵丝" src="http://beng.name/userfiles/photos/1333122081004.jpg" /><img alt="mca 标间" width="250" height="188" title="mca 标间" src="http://beng.name/userfiles/photos/1333121049738.jpg" /></p>
<p><a href="http://beng.name/userfiles/photos/1333121125307.jpg"><img alt="苍山" width="500" height="110" title="从宾馆楼顶看苍山" src="http://beng.name/userfiles/photos/1333121125307.jpg" /></a></p>
<p>&nbsp;</p>
<p>由于之前下载了攻略就一个个的按着攻略上介绍的找了，最后找了古城边上的mca，标间120每天，院子挺大挺安静，不过话说这个mca的服务还真的不怎么好晚上天冷想使用空调竟然要求加20.</p>
<p>&nbsp;</p>
<p>放了行李简单洗洗之后就由带我们来的司机带着我们去苍山景区了，在这里不得不说一下当地的宾馆和个人都能够帮忙买到便宜点的团体票，即方便了&amp;让利了游客也有利于当地人民参与旅游事业(全民总动员)，真是一举两得，某些高旅游的地方真是应当参考一下（比如栾川，查身份证那叫一个严格呀...）。</p>
<p>&nbsp;<img alt="苍山索道上下望" width="500" height="288" title="苍山索道上下望" src="http://beng.name/userfiles/photos/1331556642872.jpg" /></p>
<p>&nbsp;苍山远处望有很多的雪，但是走进了之后就看不出来了，虽然我们在坐完索道之后又爬了好久的山还是没有看到白色的雪，苍山索道大概90（往返）。</p>
<p>苍山回来古城就下午1点多了，找个地方吃了点饭，这里吃饭的种类还是很多滴，为了不被看成吃货就少写点了反正是有各种各样没见过的东西可以吃，哈哈。然后就是在古城里逛了逛了之后去了天龙八部影视城。晚上又是吃了吃饭然后到古城里又逛了逛，话说比较有名的洋人街竟然是在古城城墙外边的，难怪那么难找。</p>
<p>&nbsp;</p>
<p><img alt="大理古城" width="250" height="187" title="大理古城" src="http://beng.name/userfiles/photos/1333122408424.jpg" /><img alt="夜间的大理古城" width="250" height="188" title="夜间的大理古城" src="http://beng.name/userfiles/photos/1333122827368.jpg" /><img alt="天龙八部影视城" width="500" height="144" title="天龙八部影视城" src="http://beng.name/userfiles/photos/1331556669630.jpg" /></p>
<p>&nbsp;</p>
<p>第二天我们去了洱海，坐的游船，洱海很大据说长约40-50公里 周长就100多公里了，很大，所以用了一上午的时间。洱海很好直接上图吧。</p>
<p><img alt="洱海游船 大运号" width="500" height="175" title="洱海游船 大运号" src="http://beng.name/userfiles/photos/1331556656887.jpg" />大运号游船</p>
<p><img alt="海鸥" title="海鸥" width="250" height="187" src="http://beng.name/userfiles/photos/1333123873591.jpg" /><img alt="双廊附近的小岛" width="250" height="187" title="双廊附近的小岛" src="http://beng.name/userfiles/photos/1333123711759.jpg" /></p>
<p>在结束了游船之行之后已经中午了，在喜洲吃完饭之后去海舌参观了鱼鹰表演近距离的接触了下洱海。</p>
<p><img alt="清澈见底的湖水" title="清澈见底的湖水" width="250" height="187" src="http://beng.name/userfiles/photos/1333124056788.jpg" /><img alt="鱼鹰表演" width="250" height="187" title="鱼鹰表演" src="http://beng.name/userfiles/photos/1333124319156.jpg" /></p>
<p>下午在喜洲坐小巴车返回了下关等待晚上返回昆明，两天共消费600多/人。更多照片请看<a href="http://beng.name/app/photo/index.jsp">我的相册</a>。</p>
<p>&nbsp;</p>]]></description>
	      <guid isPermaLink="false">beng.name/news/107</guid>
	      <link><![CDATA[http://beng.name/article/atricle-107.html]]></link>
	      <pubDate><![CDATA[2012-03-30 23:09:14]]></pubDate>
	      <author><![CDATA[翟维金]]></author>
	    </item>
		
		<item>
	      <title><![CDATA[亚马逊价格变化功能【部分】]]></title>
	      <description><![CDATA[<p>开发了个功能，亚马逊价格变化，每天报告一些价格变化，<a title="亚马逊价格变化" href="http://beng.name/app/am/">http://beng.name/app/am/</a>，另外还能搜索所有收录的商品&nbsp;<a href="http://beng.name/app/am/search.jsp">http://beng.name/app/am/search.jsp</a></p>
<p>更多功能陆续实现中，最近比较忙可能比较慢。</p>]]></description>
	      <guid isPermaLink="false">beng.name/news/106</guid>
	      <link><![CDATA[http://beng.name/article/atricle-106.html]]></link>
	      <pubDate><![CDATA[2012-03-08 23:35:05]]></pubDate>
	      <author><![CDATA[翟维金]]></author>
	    </item>
		
		<item>
	      <title><![CDATA[使用crawler4j中发现的问题]]></title>
	      <description><![CDATA[<p>&nbsp;1.edu.uci.ics.crawler4j.robotstxt.RobotstxtServer.allows();方法将url全部小写了，导致本来就是重定向过的中文url %AB%CD被某些网站认为有问题。</p>
<p>2.edu.uci.ics.crawler4j.parser.Parser 在parse的时候将外链url全部小写造成和以上类似的问题。</p>
<p>3.org.apache.tika.parser.html.HtmlParser 默认的charset弄成了ISO8859-1,中文网页经常乱码。</p>
<p>先放在这里然后提交到他们的网站。</p>
<p>&nbsp;</p>]]></description>
	      <guid isPermaLink="false">beng.name/news/105</guid>
	      <link><![CDATA[http://beng.name/article/atricle-105.html]]></link>
	      <pubDate><![CDATA[2012-03-02 15:57:14]]></pubDate>
	      <author><![CDATA[翟维金]]></author>
	    </item>
		
		<item>
	      <title><![CDATA[收藏一篇mysql字符串函数的文章]]></title>
	      <description><![CDATA[<p>出处：<a href="http://www.phpv.net/html/1443.html">http://www.phpv.net/html/1443.html</a></p>
<p>&nbsp;<span style="color: rgb(81, 81, 81); font-size: 14px; line-height: 25px; text-align: left; ">对于针对字符串位置的操作，第一个位置被标记为1。</span></p>
<dl compact="" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; color: rgb(81, 81, 81); font-size: 14px; text-align: left; ">
    <dt style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">ASCII(str)</font></code></strong></dt>
    <dd style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">返回字符串<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">str</font></code>的最左面字符的ASCII代码值。</strong>如果<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">str</font></code>是空字符串，返回<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">0</font></code>。如果<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">str</font></code>是<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">NULL</font></code>，返回<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">NULL</font></code>。
    <divre style="margin-top: 0px; margin-bottom: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">mysql&gt; select ASCII('2');         -&gt; 50 mysql&gt; select ASCII(2);         -&gt; 50 mysql&gt; select ASCII('dx');         -&gt; 100
    <p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 15px; padding-left: 0px; line-height: 25px; ">也可参见ORD()函数。</p>
    </divre>
    </dd>
    <dt style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">ORD(str)</strong></font></code></dt>
    <dd style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">如果字符串str最左面字符是一个多字节字符，通过以格式<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">((first byte ASCII code)*256+(second byte ASCII code))[*256+third byte ASCII code...]</font></code>返回字符的ASCII代码值来返回多字节字符代码。如果最左面的字符不是一个多字节字符。返回与<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">ASCII()</font></code>函数返回的相同值。
    <divre style="margin-top: 0px; margin-bottom: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">mysql&gt; select ORD('2');         -&gt; 50  </divre>
    </dd>
    <dt style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">CONV(N,from_base,to_base)</strong></font></code></dt>
    <dd style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">在不同的数字基之间变换数字。返回数字<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">N</font></code>的字符串数字，从<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">from_base</font></code>基变换为<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">to_base</font></code>基，如果任何参数是<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">NULL</font></code>，返回<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">NULL</font></code>。参数<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">N</font></code>解释为一个整数，但是可以指定为一个整数或一个字符串。最小基是<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">2</font></code>且最大的基是<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">36</font></code>。如果<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">to_base</font></code>是一个负数，<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">N</font></code>被认为是一个有符号数，否则，<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">N</font></code>被当作无符号数。<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">CONV</font></code>以64位点精度工作。
    <pre style="margin-top: 0px; margin-bottom: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">
mysql&gt; select CONV(&quot;a&quot;,16,2);
        -&gt; '1010'
mysql&gt; select CONV(&quot;6E&quot;,18,8);
        -&gt; '172'
mysql&gt; select CONV(-17,10,-18);
        -&gt; '-H'
mysql&gt; select CONV(10+&quot;10&quot;+'10'+0xa,10,10);
        -&gt; '40'
 </pre>
    </dd>
    <dt style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">BIN(N)</strong></font></code></dt>
    <dd style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">返回二进制值<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">N</font></code>的一个字符串表示，在此<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">N</font></code>是一个长整数(<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">BIGINT</font></code>)数字，这等价于<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">CONV(N,10,2)</font></code>。如果<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">N</font></code>是<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">NULL</font></code>，返回<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">NULL</font></code>。
    <pre style="margin-top: 0px; margin-bottom: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">
mysql&gt; select BIN(12);
        -&gt; '1100'
</pre>
    </dd>
    <dt style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">OCT(N)</font></code></strong></dt>
    <dd style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">返回八进制值<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">N</font></code>的一个字符串的表示，在此<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">N</font></code>是一个长整型数字，这等价于<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">CONV(N,10,8)</font></code>。如果<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">N</font></code>是NULL，返回<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">NULL</font></code>。
    <pre style="margin-top: 0px; margin-bottom: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">
mysql&gt; select OCT(12);
        -&gt; '14'
 </pre>
    </dd>
    <dt style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">HEX(N)</font></code></strong></dt>
    <dd style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">返回十六进制值<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">N</font></code>一个字符串的表示，在此<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">N</font></code>是一个长整型(<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">BIGINT</font></code>)数字，这等价于<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">CONV(N,10,16)</font></code>。如果<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">N</font></code>是<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">NULL</font></code>，返回<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">NULL</font></code>。
    <pre style="margin-top: 0px; margin-bottom: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">
mysql&gt; select HEX(255);
        -&gt; 'FF'
 </pre>
    </dd>
    <dt style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">CHAR(N,...)</font></code></strong></dt>
    <dd style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">CHAR()</font></code>将参数解释为整数并且返回由这些整数的ASCII代码字符组成的一个字符串。</strong><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">NULL</font></code>值被跳过。
    <pre style="margin-top: 0px; margin-bottom: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">
mysql&gt; select CHAR(77,121,83,81,'76');
        -&gt; 'MySQL'
mysql&gt; select CHAR(77,77.3,'77.3');
        -&gt; 'MMM'
 </pre>
    </dd>
    <dt style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">CONCAT(str1,str2,...)</font></code></strong></dt>
    <dd style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">返回来自于参数连结的字符串</strong>。如果任何参数是<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">NULL</font></code>，返回<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">NULL</font></code>。可以有超过2个的参数。一个数字参数被变换为等价的字符串形式。
    <pre style="margin-top: 0px; margin-bottom: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">
mysql&gt; select CONCAT('My', 'S', 'QL');
        -&gt; 'MySQL'
mysql&gt; select CONCAT('My', NULL, 'QL');
        -&gt; NULL
mysql&gt; select CONCAT(14.3);
        -&gt; '14.3'
</pre>
    </dd>
    <dt style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">LENGTH(str)</font></code></strong></dt>
    <dt style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">OCTET_LENGTH(str)</font></code></strong></dt>
    <dt style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">CHAR_LENGTH(str)</font></code></strong></dt>
    <dt style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">CHARACTER_LENGTH(str)</strong></font></code></dt>
    <dd style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">返回字符串<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">str</font></code>的长度。
    <pre style="margin-top: 0px; margin-bottom: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">
mysql&gt; select LENGTH('text');
        -&gt; 4
mysql&gt; select OCTET_LENGTH('text');
        -&gt; 4
</pre>
    <p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 15px; padding-left: 0px; line-height: 25px; ">注意，对于多字节字符，其CHAR_LENGTH()仅计算一次。</p>
    </dd>
    <dt style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">LOCATE(substr,str)</strong></font></code></dt>
    <dt style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">POSITION(substr IN str)</strong></font></code></dt>
    <dd style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">返回子串<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">substr</font></code>在字符串<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">str</font></code>第一个出现的位置，如果<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">substr</font></code>不是在<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">str</font></code>里面，返回<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">0</font></code>.
    <divre style="margin-top: 0px; margin-bottom: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">mysql&gt; select LOCATE('bar', 'foobarbar');         -&gt; 4 mysql&gt; select LOCATE('xbar', 'foobar');         -&gt; 0
    <pre style="margin-top: 0px; margin-bottom: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">
该函数是多字节可靠的。  </pre>
    </divre>
    </dd>
    <dt style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">LOCATE(substr,str,pos)</strong></font></code></dt>
    <dd style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">返回子串<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">substr</font></code>在字符串<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">str</font></code>第一个出现的位置，从位置<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">pos</font></code>开始。如果<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">substr</font></code>不是在<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">str</font></code>里面，返回<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">0</font></code>。
    <pre style="margin-top: 0px; margin-bottom: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">
mysql&gt; select LOCATE('bar', 'foobarbar',5);
        -&gt; 7
</pre>
    <p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 15px; padding-left: 0px; line-height: 25px; ">这函数是多字节可靠的。</p>
    </dd>
    <dt style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">INSTR(str,substr)</strong></font></code></dt>
    <dd style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">返回子串<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">substr</font></code>在字符串<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">str</font></code>中的第一个出现的位置。这与有2个参数形式的<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">LOCATE()</font></code>相同，除了参数被颠倒。
    <divre style="margin-top: 0px; margin-bottom: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">mysql&gt; select INSTR('foobarbar', 'bar');         -&gt; 4 mysql&gt; select INSTR('xbar', 'foobar');         -&gt; 0
    <p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 15px; padding-left: 0px; line-height: 25px; ">这函数是多字节可靠的。</p>
    </divre>
    </dd>
    <dt style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">LPAD(str,len,padstr)</strong></font></code></dt>
    <dd style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">返回字符串<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">str</font></code>，左面用字符串<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">padstr</font></code>填补直到<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">str</font></code>是<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">len</font></code>个字符长。
    <divre style="margin-top: 0px; margin-bottom: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">mysql&gt; select LPAD('hi',4,'??');         -&gt; '??hi'  </divre>
    </dd>
    <dt style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">RPAD(str,len,padstr)</strong></font></code></dt>
    <dd style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">返回字符串<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">str</font></code>，右面用字符串<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">padstr</font></code>填补直到<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">str</font></code>是<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">len</font></code>个字符长。 &nbsp;
    <pre style="margin-top: 0px; margin-bottom: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">
mysql&gt; select RPAD('hi',5,'?');
        -&gt; 'hi???'
</pre>
    </dd>
    <dt style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">LEFT(str,len)</strong></font></code></dt>
    <dd style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">返回字符串<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">str</font></code>的最左面<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">len</font></code>个字符。
    <pre style="margin-top: 0px; margin-bottom: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">
mysql&gt; select LEFT('foobarbar', 5);
        -&gt; 'fooba'
</pre>
    <p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 15px; padding-left: 0px; line-height: 25px; ">该函数是多字节可靠的。</p>
    </dd>
    <dt style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">RIGHT(str,len)</strong></font></code></dt>
    <dd style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">返回字符串<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">str</font></code>的最右面<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">len</font></code>个字符<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">。</font></code>
    <divre style="margin-top: 0px; margin-bottom: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">mysql&gt; select RIGHT('foobarbar', 4);         -&gt; 'rbar'
    <p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 15px; padding-left: 0px; line-height: 25px; ">该函数是多字节可靠的。</p>
    </divre>
    </dd>
    <dt style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">SUBSTRING(str,pos,len)</strong></font></code></dt>
    <dt style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">SUBSTRING(str FROM pos FOR len)</strong></font></code></dt>
    <dt style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">MID(str,pos,len)</strong></font></code></dt>
    <dd style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">从字符串<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">str</font></code>返回一个<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">len</font></code>个字符的子串，从位置<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">pos</font></code>开始。使用<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">FROM</font></code>的变种形式是ANSI SQL92语法。
    <divre style="margin-top: 0px; margin-bottom: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">mysql&gt; select SUBSTRING('Quadratically',5,6);         -&gt; 'ratica'
    <p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 15px; padding-left: 0px; line-height: 25px; ">该函数是多字节可靠的。</p>
    </divre>
    </dd>
    <dt style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">SUBSTRING(str,pos)</strong></font></code></dt>
    <dt style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">SUBSTRING(str FROM pos)</strong></font></code></dt>
    <dd style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">从字符串<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">str</font></code>的起始位置<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">pos</font></code>返回一个子串。
    <divre style="margin-top: 0px; margin-bottom: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">mysql&gt; select SUBSTRING('Quadratically',5);         -&gt; 'ratically' mysql&gt; select SUBSTRING('foobarbar' FROM 4);         -&gt; 'barbar'
    <p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 15px; padding-left: 0px; line-height: 25px; ">该函数是多字节可靠的。</p>
    </divre>
    </dd>
    <dt style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">SUBSTRING_INDEX(str,delim,count)</strong></font></code></dt>
    <dd style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">返回从字符串<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">str</font></code>的第<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">count</font></code>个出现<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">的</font></code>分隔符<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">delim</font></code>之后的子串。如果<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">count</font></code>是正数，返回最后的分隔符到左边(从左边数) 的所有字符。如果<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">count</font></code>是负数，返回最后的分隔符到右边的所有字符(从右边数)。
    <divre style="margin-top: 0px; margin-bottom: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">mysql&gt; select SUBSTRING_INDEX('www.mysql.com', '.', 2);         -&gt; 'www.mysql' mysql&gt; select SUBSTRING_INDEX('www.mysql.com', '.', -2);         -&gt; 'mysql.com'
    <p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 15px; padding-left: 0px; line-height: 25px; ">该函数对多字节是可靠的。</p>
    </divre>
    </dd>
    <dt style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">LTRIM(str)</strong></font></code></dt>
    <dd style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">返回删除了其前置空格字符的字符串<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">str</font></code>。
    <divre style="margin-top: 0px; margin-bottom: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">mysql&gt; select LTRIM('  barbar');         -&gt; 'barbar' </divre>
    </dd>
    <dt style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">RTRIM(str)</strong></font></code></dt>
    <dd style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">返回删除了其拖后空格字符的字符串<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">str</font></code>。
    <pre style="margin-top: 0px; margin-bottom: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">
mysql&gt; select RTRIM('barbar   ');
        -&gt; 'barbar'
</pre>
    <pre style="margin-top: 0px; margin-bottom: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">
该函数对多字节是可靠的。  </pre>
    </dd>
    <dt style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">TRIM([[BOTH | LEADING | TRAILING] [remstr] FROM] str)</strong></font></code></dt>
    <dd style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">返回字符串<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">str</font></code>，其所有<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">remstr</font></code>前缀或后缀被删除了。如果没有修饰符<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">BOTH</font></code>、<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">LEADING</font></code>或<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">TRAILING</font></code>给出，<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">BOTH</font></code>被假定。如果<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">remstr</font></code>没被指定，空格被删除。
    <pre style="margin-top: 0px; margin-bottom: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">
mysql&gt; select TRIM('  bar   ');
        -&gt; 'bar'
mysql&gt; select TRIM(LEADING 'x' FROM 'xxxbarxxx');
        -&gt; 'barxxx'
mysql&gt; select TRIM(BOTH 'x' FROM 'xxxbarxxx');
        -&gt; 'bar'
mysql&gt; select TRIM(TRAILING 'xyz' FROM 'barxxyz');
        -&gt; 'barx'
</pre>
    <p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 15px; padding-left: 0px; line-height: 25px; ">该函数对多字节是可靠的。</p>
    </dd>
    <dt style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">SOUNDEX(str)</strong></font></code></dt>
    <dd style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">返回<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">str</font></code>的一个同音字符串。听起来&ldquo;大致相同&rdquo;的2个字符串应该有相同的同音字符串。一个&ldquo;标准&rdquo;的同音字符串长是4个字符，但是<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">SOUNDEX()</font></code>函数返回一个任意长的字符串。你可以在结果上使用<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">SUBSTRING()</font></code>得到一个&ldquo;标准&rdquo;的 同音串。所有非数字字母字符在给定的字符串中被忽略。所有在A-Z之外的字符国际字母被当作元音。
    <divre style="margin-top: 0px; margin-bottom: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">mysql&gt; select SOUNDEX('Hello');         -&gt; 'H400' mysql&gt; select SOUNDEX('Quadratically');         -&gt; 'Q36324'  </divre>
    </dd>
    <dt style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">SPACE(N)</strong></font></code></dt>
    <dd style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">返回由<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">N</font></code>个空格字符组成的一个字符串。
    <pre style="margin-top: 0px; margin-bottom: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">
mysql&gt; select SPACE(6);
        -&gt; '      '
 </pre>
    </dd>
    <dt style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">REPLACE(str,from_str,to_str)</strong></font></code></dt>
    <dd style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">返回字符串<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">str</font></code>，其字符串<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">from_str</font></code>的所有出现由字符串<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">to_str</font></code>代替。
    <pre style="margin-top: 0px; margin-bottom: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">
mysql&gt; select REPLACE('www.mysql.com', 'w', 'Ww');
        -&gt; 'WwWwWw.mysql.com'
</pre>
    <p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 15px; padding-left: 0px; line-height: 25px; ">该函数对多字节是可靠的。</p>
    </dd>
    <dt style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">REPEAT(str,count)</strong></font></code></dt>
    <dd style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">返回由重复<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">count</font></code>Times次的字符串<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">str</font></code>组成的一个字符串。如果<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">count &lt;= 0</font></code>，返回一个空字符串。如果<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">str</font></code>或<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">count</font></code>是<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">NULL</font></code>，返回<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">NULL</font></code>。
    <divre style="margin-top: 0px; margin-bottom: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">mysql&gt; select REPEAT('MySQL', 3);         -&gt; 'MySQLMySQLMySQL'  </divre>
    </dd>
    <dt style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">REVERSE(str)</strong></font></code></dt>
    <dd style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">返回颠倒字符顺序的字符串<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">str</font></code>。
    <pre style="margin-top: 0px; margin-bottom: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">
mysql&gt; select REVERSE('abc');
        -&gt; 'cba'
</pre>
    <p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 15px; padding-left: 0px; line-height: 25px; ">该函数对多字节可靠的。</p>
    </dd>
    <dt style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">INSERT(str,pos,len,newstr)</strong></font></code></dt>
    <dd style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">返回字符串<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">str</font></code>，在位置<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">pos</font></code>起始的子串且<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">len</font></code>个字符长得子串由字符串<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">newstr</font></code>代替。
    <divre style="margin-top: 0px; margin-bottom: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">mysql&gt; select INSERT('Quadratic', 3, 4, 'What');         -&gt; 'QuWhattic'
    <p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 15px; padding-left: 0px; line-height: 25px; ">该函数对多字节是可靠的。</p>
    </divre>
    </dd>
    <dt style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">ELT(N,str1,str2,str3,...)</strong></font></code></dt>
    <dd style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">如果<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">N</font></code>=&nbsp;<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">1</font></code>，返回<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">str1</font></code>，如果<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">N</font></code>=&nbsp;<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">2</font></code>，返回<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">str2</font></code>，等等。如果<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">N</font></code>小于<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">1</font></code>或大于参数个数，返回<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">NULL</font></code>。<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">ELT()</font></code>是<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">FIELD()</font></code>反运算。
    <divre style="margin-top: 0px; margin-bottom: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">mysql&gt; select ELT(1, 'ej', 'Heja', 'hej', 'foo');         -&gt; 'ej' mysql&gt; select ELT(4, 'ej', 'Heja', 'hej', 'foo');         -&gt; 'foo' </divre>
    </dd>
    <dt style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">FIELD(str,str1,str2,str3,...)</strong></font></code></dt>
    <dd style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">返回<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">str</font></code>在<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">str1</font></code>,&nbsp;<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">str2</font></code>,&nbsp;<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">str3</font></code>,&nbsp;<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">...</font></code>清单的索引。如果<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">str</font></code>没找到，返回<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">0</font></code>。<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">FIELD()</font></code>是<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">ELT()</font></code>反运算。
    <pre style="margin-top: 0px; margin-bottom: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">
mysql&gt; select FIELD('ej', 'Hej', 'ej', 'Heja', 'hej', 'foo');
        -&gt; 2
mysql&gt; select FIELD('fo', 'Hej', 'ej', 'Heja', 'hej', 'foo');
        -&gt; 0
</pre>
    </dd>
    <dt style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">FIND_IN_SET(str,strlist)</strong></font></code></dt>
    <dd style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">如果字符串<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">str</font></code>在由<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">N</font></code>子串组成的表<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">strlist</font></code>之中，返回一个<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">1</font></code>到<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">N</font></code>的值。一个字符串表是被<samp style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">&ldquo;,&rdquo;</font></samp>分隔的子串组成的一个字符串。如果第一个参数是一个常数字符串并且第二个参数是一种类型为<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">SET</font></code>的列，<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">FIND_IN_SET()</font></code>函数被优化而使用位运算！如果<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">str</font></code>不是在<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">strlist</font></code>里面或如果<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">strlist</font></code>是空字符串，返回<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">0</font></code>。如果任何一个参数是<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">NULL</font></code>，返回<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">NULL</font></code>。如果第一个参数包含一个<samp style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">&ldquo;,&rdquo;</font></samp>，该函数将工作不正常。
    <pre style="margin-top: 0px; margin-bottom: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">
mysql&gt; SELECT FIND_IN_SET('b','a,b,c,d');
        -&gt; 2
 </pre>
    </dd>
    <dt style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">MAKE_SET(bits,str1,str2,...)</strong></font></code></dt>
    <dd style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">返回一个集合 (包含由<samp style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">&ldquo;,&rdquo;</font></samp>字符分隔的子串组成的一个字符串)，由相应的位在<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">bits</font></code>集合中的的字符串组成。<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">str1</font></code>对应于位0，<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">str2</font></code>对应位1，等等。在<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">str1</font></code>,&nbsp;<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">str2</font></code>,&nbsp;<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">...</font></code>中的<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">NULL</font></code>串不添加到结果中。
    <pre style="margin-top: 0px; margin-bottom: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">
mysql&gt; SELECT MAKE_SET(1,'a','b','c');
        -&gt; 'a'
mysql&gt; SELECT MAKE_SET(1 | 4,'hello','nice','world');
        -&gt; 'hello,world'
mysql&gt; SELECT MAKE_SET(0,'a','b','c');
        -&gt; ''
</pre>
    </dd>
    <dt style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">EXPORT_SET(bits,on,off,[separator,[number_of_bits]])</strong></font></code></dt>
    <dd style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">返回一个字符串，在这里对于在&ldquo;bits&rdquo;中设定每一位，你得到一个&ldquo;on&rdquo;字符串，并且对于每个复位(reset)的位，你得到一个&ldquo;off&rdquo;字符串。每个字符串用&ldquo;separator&rdquo;分隔(缺省&ldquo;,&rdquo;)，并且只有&ldquo;bits&rdquo;的&ldquo;number_of_bits&rdquo; (缺省64)位被使用。
    <pre style="margin-top: 0px; margin-bottom: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">
mysql&gt; select EXPORT_SET(5,'Y','N',',',4)
        -&gt; Y,N,Y,N 
</pre>
    </dd>
    <dt style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">LCASE(str)</font></code></strong></dt>
    <dt style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">LOWER(str)</strong></font></code></dt>
    <dd style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">返回字符串<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">str</font></code>，根据当前字符集映射(缺省是ISO-8859-1 Latin1)把所有的字符改变成小写。该函数对多字节是可靠的。
    <pre style="margin-top: 0px; margin-bottom: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">
mysql&gt; select LCASE('QUADRATICALLY');
        -&gt; 'quadratically'
 </pre>
    </dd>
    <dt style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">UCASE(str)</font></code></strong></dt>
    <dt style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">UPPER(str)</strong></font></code></dt>
    <dd style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">返回字符串<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">str</font></code>，根据当前字符集映射(缺省是ISO-8859-1 Latin1)把所有的字符改变成大写。该函数对多字节是可靠的。
    <pre style="margin-top: 0px; margin-bottom: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">
mysql&gt; select UCASE('Hej');
        -&gt; 'HEJ'
</pre>
    <p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 15px; padding-left: 0px; line-height: 25px; ">该函数对多字节是可靠的。</p>
    </dd>
    <dt style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">LOAD_FILE(file_name)</strong></font></code></dt>
    <dd style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">读入文件并且作为一个字符串返回文件内容。文件必须在服务器上，你必须指定到文件的完整路径名，而且你必须有<strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">file</strong>权限。文件必须所有内容都是可读的并且小于<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">max_allowed_packet</font></code>。如果文件不存在或由于上面原因之一不能被读出，函数返回<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">NULL</font></code>。
    <divre style="margin-top: 0px; margin-bottom: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">mysql&gt; UPDATE table_name            SET blob_column=LOAD_FILE(&quot;/tmp/picture&quot;)            WHERE id=1;  </divre>
    </dd>
</dl>
<p>&nbsp;</p>
<p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 15px; padding-left: 0px; line-height: 25px; color: rgb(81, 81, 81); font-size: 14px; text-align: left; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">MySQL</strong>必要时自动变换数字为字符串，并且反过来也如此：
<divre style="margin-top: 0px; margin-bottom: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">mysql&gt; SELECT 1+&quot;1&quot;;         -&gt; 2 mysql&gt; SELECT CONCAT(2,' test');         -&gt; '2 test' </divre>
</p>
<p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 15px; padding-left: 0px; line-height: 25px; color: rgb(81, 81, 81); font-size: 14px; text-align: left; ">如果你想要明确地变换一个数字到一个字符串，把它作为参数传递到<code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><font style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">CONCAT()</font></code>。</p>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 15px; padding-left: 0px; line-height: 25px; color: rgb(81, 81, 81); font-size: 14px; text-align: left; ">如果字符串函数提供一个二进制字符串作为参数，结果字符串也是一个二进制字符串。被变换到一个字符串的数字被当作是一个二进制字符串。这仅影响比较。</div>
<p>&nbsp;</p>]]></description>
	      <guid isPermaLink="false">beng.name/news/104</guid>
	      <link><![CDATA[http://beng.name/article/atricle-104.html]]></link>
	      <pubDate><![CDATA[2012-02-23 15:00:18]]></pubDate>
	      <author><![CDATA[翟维金]]></author>
	    </item>
		
		<item>
	      <title><![CDATA[比价网站的核心技术]]></title>
	      <description><![CDATA[<p>有心用爬虫收集一下京东和亚马逊的商品及价格信息，在做的过程中才发现不知道怎么准确定位一种商品，我觉得这就是像etao.com这类比价网站的主要的核心技术了吧，因为单独爬一个商品的价格很容易就能实现了。</p>
<p>仔细看了下应该不是直接用二维码来区分的，因为在输入描述信息时候依然能够比价。</p>
<p>我的判断是他们可能做到了商品描述(厂商 产品名 型号)比如 用 &ldquo;<span id="btAsinTitle">苹果 iPod touch 4代 8GB&rdquo; 同条形码之间的映射，在爬虫工作时候按照自己一定的规则来爬出商品的名称。</span></p>
<p>这样无论是从描述信息还是条形码都能基本准确定位到一种商品。所以在建立模型以及准备数据的时候呢就要求按照统一的规格来建立描述信息，并且给补充条形码信息预留字段。同时还要给这商品打上标签，就像搜索的索引或者html中的关键词一样。或者和搜索引擎一块做？这个方面我还不是太懂，我需要的东西应该不简单的就是个lucene吧。</p>
<p>&nbsp;</p>]]></description>
	      <guid isPermaLink="false">beng.name/news/103</guid>
	      <link><![CDATA[http://beng.name/article/atricle-103.html]]></link>
	      <pubDate><![CDATA[2012-02-21 22:54:22]]></pubDate>
	      <author><![CDATA[翟维金]]></author>
	    </item>
		
		<item>
	      <title><![CDATA[邮政慢件查询]]></title>
	      <description><![CDATA[<p><span style="font-size: larger; ">&nbsp;</span><a target="_blank" href="http://yjcx.chinapost.com.cn/"><span style="font-size: larger; ">邮政慢件查询</span></a><span style="font-size: larger; ">的网址，真不好找啊。<a title=" 邮政慢件查询" href="http://yjcx.chinapost.com.cn/">http://yjcx.chinapost.com.cn/</a></span></p>]]></description>
	      <guid isPermaLink="false">beng.name/news/102</guid>
	      <link><![CDATA[http://beng.name/article/atricle-102.html]]></link>
	      <pubDate><![CDATA[2012-02-20 13:10:13]]></pubDate>
	      <author><![CDATA[翟维金]]></author>
	    </item>
		
		<item>
	      <title><![CDATA[京东拍卖插件和京东查看历史价格插件]]></title>
	      <description><![CDATA[<p>&nbsp;为了方便使用京东，为了购物方便搞了两个chrome浏览器的插件，京东拍卖插件 京东查看历史价格</p>
<p><a target="_blank" href="http://beng.name/js/jd-paimai.user.js">拍卖</a>&nbsp;：<a target="_blank" href="http://beng.name/js/jd-paimai.user.js">http://beng.name/js/jd-paimai.user.js</a></p>
<p><a target="_blank" href="http://beng.name/js/jd-paimai.user.js">查看历史价格</a>：<a href="http://beng.name/js/jd-jiage.user.js">http://beng.name/js/jd-jiage.user.js</a></p>
<p>仅供交流使用！</p>
<p>感谢<a target="_blank" href="http://kkdata.com">kkdata.com</a>&nbsp;以及发明火车票订票程序的程序员们！</p>
<p><img alt="京东查看历史价格" width="596" height="329" src="/userfiles/image/jingdong-chajian.png" /></p>]]></description>
	      <guid isPermaLink="false">beng.name/news/101</guid>
	      <link><![CDATA[http://beng.name/article/atricle-101.html]]></link>
	      <pubDate><![CDATA[2012-02-15 14:19:49]]></pubDate>
	      <author><![CDATA[翟维金]]></author>
	    </item>
		
		<item>
	      <title><![CDATA[快速缩放或移动Google地球将产生立体感觉]]></title>
	      <description><![CDATA[<p>&nbsp;由于不同高度的物体在移动观看时候他们变大变小的速度是不同的，因此眼睛就产生了立体的感就。原本立体感不是十分强的图片中的地形一下子就凸显出来了。</p>
<p>就像趴在玻璃上的蚊子一样，不是很好找，但是只要它一起飞就很容易发现它了，哈哈，通俗不！？</p>
<p>当浏览运动的平面卫星地图时候，原本没有立体感就的地图会体现出立体感，比如山岭的高度等。</p>
<p>欢迎体验，<a target="_blank" href="http://beng.name/userfiles/other/3d-fell.kmz">3d-fell.kmz</a></p>
<p>&nbsp;</p>]]></description>
	      <guid isPermaLink="false">beng.name/news/100</guid>
	      <link><![CDATA[http://beng.name/article/atricle-100.html]]></link>
	      <pubDate><![CDATA[2012-02-13 10:17:19]]></pubDate>
	      <author><![CDATA[翟维金]]></author>
	    </item>
		
		<item>
	      <title><![CDATA[显示器驱动程序已经停止响应，并且已恢复 win7 解决]]></title>
	      <description><![CDATA[<p>老电脑装了win7 用qq影音播放视频时候出现 显示器驱动程序已经停止响应，并且已恢复。偶尔还蓝屏。</p>
<p>后来查了半天说可能是驱动问题，更新驱动后仍然不行。后来发现可能是驱动不支持硬件加速的问题，看了下qq影音果然不能关闭硬件加速功能，安装迅雷看看播放视频，终于不黑屏了</p>
<p>&nbsp;</p>
<p>电脑：dell 1501</p>
<p>qq影音 最新版</p>]]></description>
	      <guid isPermaLink="false">beng.name/news/99</guid>
	      <link><![CDATA[http://beng.name/article/atricle-99.html]]></link>
	      <pubDate><![CDATA[2012-02-02 12:13:30]]></pubDate>
	      <author><![CDATA[翟维金]]></author>
	    </item>
		
		<item>
	      <title><![CDATA[数字转换人民币大写金额工具]]></title>
	      <description><![CDATA[<p>&nbsp;地址:<a target="_blank" href="http://beng.name/app/number/numberToRMB.jsp">http://beng.name/app/number/numberToRMB.jsp</a></p>
<p>本工具具有将阿拉伯数字批量转换为人民币大写金额的功能，支持批量转换，灵感来自谷歌翻译。欢迎使用...</p>
<p>意见和建议请评论本文章</p>
<p>&nbsp;</p>]]></description>
	      <guid isPermaLink="false">beng.name/news/97</guid>
	      <link><![CDATA[http://beng.name/article/atricle-97.html]]></link>
	      <pubDate><![CDATA[2012-01-11 17:45:03]]></pubDate>
	      <author><![CDATA[翟维金]]></author>
	    </item>
		
		<item>
	      <title><![CDATA[春运抢票系统]]></title>
	      <description><![CDATA[<p>在12306.cn买车票时候最怕遇到 &ldquo;当前访问用户过多，请稍后重试!&rdquo;的问题，连抢的机会都没有了，就像坑爹的抢小米手机的网站一样，无法登陆的人直接都没机会了。</p>
<p>为解决这个问题开发了个小页面，可以来试试，一定要提前试 哈哈。<a target="_blank" href="http://beng.name/app/orderTraintickets.jsp">春运抢票系统</a>&nbsp; 快来抢吧。</p>
<p>&nbsp;<img width="500" height="111" alt="" src="/userfiles/image/12306denglu.jpg" /></p>]]></description>
	      <guid isPermaLink="false">beng.name/news/96</guid>
	      <link><![CDATA[http://beng.name/article/atricle-96.html]]></link>
	      <pubDate><![CDATA[2012-01-05 13:16:10]]></pubDate>
	      <author><![CDATA[史凤琴]]></author>
	    </item>
		
		<item>
	      <title><![CDATA[黑店列表]]></title>
	      <description><![CDATA[<p>以下是遭遇不好遭遇的黑店，供大家参考：</p>
<p>&nbsp;黑店1. QQ：1175651245 北京市海淀区中关村科贸写字楼16层1612B 010-82536027 82537396（还没问上两句就拉黑，很伤心，有这么对待顾客的吗？货好不好我就不知道了，在我个人看来中关村就是个水货横行的地方，翻新的就更不会少，胆小的还是多花钱买个放心的好）</p>
<p>2. 待续...</p>]]></description>
	      <guid isPermaLink="false">beng.name/news/93</guid>
	      <link><![CDATA[http://beng.name/article/atricle-93.html]]></link>
	      <pubDate><![CDATA[2011-12-17 10:12:32]]></pubDate>
	      <author><![CDATA[翟维金]]></author>
	    </item>
		
		<item>
	      <title><![CDATA[北京空气质量变化：14天连拍同一场景]]></title>
	      <description><![CDATA[<p>&nbsp;凤凰网的图片，我ps了一下放到这里了</p>
<p><a target="_blank" href="/userfiles/photos/tq.jpg"><img width="5" height="47" alt="" src="/userfiles/photos/tq.jpg" /></a></p>]]></description>
	      <guid isPermaLink="false">beng.name/news/92</guid>
	      <link><![CDATA[http://beng.name/article/atricle-92.html]]></link>
	      <pubDate><![CDATA[2011-12-06 13:20:40]]></pubDate>
	      <author><![CDATA[翟维金]]></author>
	    </item>
		
		<item>
	      <title><![CDATA[在线代理]]></title>
	      <description><![CDATA[<p>在线代理网站是个不错的东西，是你不用更改电脑设置来实现代理上网翻墙等。</p>
<p>以下是别人的内容，自己感觉&nbsp;<a style="color: rgb(0, 68, 153); text-decoration: none; " href="https://flyproxy.com/"><span style="color: rgb(255, 0, 0); ">https://flyproxy.com/</span></a>&nbsp;和&nbsp;<a style="color: rgb(0, 68, 153); text-decoration: none; " href="https://www.kproxy.com/"><span style="color: rgb(255, 0, 0); ">https://www.kproxy.com</span></a>&nbsp;很不错，就是kproxy容易出现服务器超载现象。</p>
<p>&nbsp;</p>
<p>-------------------------------</p>
<p><strong>以前推荐的</strong></p>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 15px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; list-style-type: none; list-style-position: initial; list-style-image: initial; font-size: 14px; line-height: 22px; text-align: left; "><a style="color: rgb(0, 68, 153); text-decoration: none; " href="http://sskb.cn/proxy/">http://sskb.cn/proxy/</a></div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 15px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; list-style-type: none; list-style-position: initial; list-style-image: initial; font-size: 14px; line-height: 22px; text-align: left; ">这个代理的特点是，访问国内网站速度快，国外速度慢。<br style="height: 0px; overflow-x: hidden; overflow-y: hidden; " />
<br style="height: 0px; overflow-x: hidden; overflow-y: hidden; " />
<strong>普通web代理</strong></div>
<ul style="margin-top: 0px; margin-right: 28px; margin-bottom: 15px; margin-left: 38px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; list-style-type: none; list-style-position: initial; list-style-image: initial; color: rgb(51, 51, 51); text-align: left; font-size: 12px; ">
    <li style="line-height: 20px; font-size: 13px; list-style-type: square; list-style-position: outside; list-style-image: initial; margin-bottom: 8px; "><a style="color: rgb(0, 68, 153); text-decoration: none; " href="http://www.9i7.cn/">http://www.9i7.cn/</a></li>
    <li style="line-height: 20px; font-size: 13px; list-style-type: square; list-style-position: outside; list-style-image: initial; margin-bottom: 8px; "><a style="color: rgb(0, 68, 153); text-decoration: none; " href="http://rapidwire.net/">http://rapidwire.net/</a></li>
    <li style="line-height: 20px; font-size: 13px; list-style-type: square; list-style-position: outside; list-style-image: initial; margin-bottom: 8px; "><a style="color: rgb(0, 68, 153); text-decoration: none; " href="http://www.httpsurf.com/">http://www.httpsurf.com/</a></li>
    <li style="line-height: 20px; font-size: 13px; list-style-type: square; list-style-position: outside; list-style-image: initial; margin-bottom: 8px; "><a style="color: rgb(0, 68, 153); text-decoration: none; " href="http://youtubeproxy.org/">http://youtubeproxy.org/</a></li>
    <li style="line-height: 20px; font-size: 13px; list-style-type: square; list-style-position: outside; list-style-image: initial; margin-bottom: 8px; "><a style="color: rgb(0, 68, 153); text-decoration: none; " href="http://www.proxydream.com/">http://www.proxydream.com/</a></li>
</ul>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 15px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; list-style-type: none; list-style-position: initial; list-style-image: initial; font-size: 14px; line-height: 22px; text-align: left; "><strong>带安全链接web代理 https</strong></div>
<ul style="margin-top: 0px; margin-right: 28px; margin-bottom: 15px; margin-left: 38px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; list-style-type: none; list-style-position: initial; list-style-image: initial; color: rgb(51, 51, 51); text-align: left; font-size: 12px; ">
    <li style="line-height: 20px; font-size: 13px; list-style-type: square; list-style-position: outside; list-style-image: initial; margin-bottom: 8px; "><a style="color: rgb(0, 68, 153); text-decoration: none; " href="http://aniscartujo.com/webproxy/">http://aniscartujo.com/webproxy/</a></li>
    <li style="line-height: 20px; font-size: 13px; list-style-type: square; list-style-position: outside; list-style-image: initial; margin-bottom: 8px; "><a style="color: rgb(0, 68, 153); text-decoration: none; " href="https://sureproxy.com/">https://sureproxy.com/</a></li>
    <li style="line-height: 20px; font-size: 13px; list-style-type: square; list-style-position: outside; list-style-image: initial; margin-bottom: 8px; "><a style="color: rgb(0, 68, 153); text-decoration: none; " href="https://2hide.net/">https://2hide.net</a></li>
    <li style="line-height: 20px; font-size: 13px; list-style-type: square; list-style-position: outside; list-style-image: initial; margin-bottom: 8px; "><a style="color: rgb(0, 68, 153); text-decoration: none; " href="https://proxify.net/">https://proxify.net/</a></li>
    <li style="line-height: 20px; font-size: 13px; list-style-type: square; list-style-position: outside; list-style-image: initial; margin-bottom: 8px; "><a style="color: rgb(0, 68, 153); text-decoration: none; " href="https://www.bypassfiltering.com/proxy/000010A/x-proxy/start">https://www.bypassfiltering.com/proxy/000010A/x-proxy/start</a></li>
    <li style="line-height: 20px; font-size: 13px; list-style-type: square; list-style-position: outside; list-style-image: initial; margin-bottom: 8px; "><a style="color: rgb(0, 68, 153); text-decoration: none; " href="https://www.getunblocked.com/now/000010A/x-proxy/start">https://www.getunblocked.com/now/000010A/x-proxy/start</a></li>
    <li style="line-height: 20px; font-size: 13px; list-style-type: square; list-style-position: outside; list-style-image: initial; margin-bottom: 8px; "><a style="color: rgb(0, 68, 153); text-decoration: none; " href="https://www.kproxy.com/">https://www.kproxy.com</a></li>
    <li style="line-height: 20px; font-size: 13px; list-style-type: square; list-style-position: outside; list-style-image: initial; margin-bottom: 8px; "><a style="color: rgb(0, 68, 153); text-decoration: none; " href="https://www.hiddenwebbrowser.com/">https://www.hiddenwebbrowser.com</a></li>
    <li style="line-height: 20px; font-size: 13px; list-style-type: square; list-style-position: outside; list-style-image: initial; margin-bottom: 8px; "><a style="color: rgb(0, 68, 153); text-decoration: none; " href="https://www.zarafe.com/">https://www.zarafe.com</a></li>
    <li style="line-height: 20px; font-size: 13px; list-style-type: square; list-style-position: outside; list-style-image: initial; margin-bottom: 8px; "><a style="color: rgb(0, 68, 153); text-decoration: none; " href="https://proxysystems.net/proxy/">https://proxysystems.net/proxy/</a>&nbsp;</li>
    <li style="line-height: 20px; font-size: 13px; list-style-type: square; list-style-position: outside; list-style-image: initial; margin-bottom: 8px; "><a style="color: rgb(0, 68, 153); text-decoration: none; " href="https://flyproxy.com/">https://flyproxy.com/</a></li>
</ul>
<p>&nbsp;</p>]]></description>
	      <guid isPermaLink="false">beng.name/news/91</guid>
	      <link><![CDATA[http://beng.name/article/atricle-91.html]]></link>
	      <pubDate><![CDATA[2011-11-20 17:16:04]]></pubDate>
	      <author><![CDATA[翟维金]]></author>
	    </item>
		
		<item>
	      <title><![CDATA[我的痤疮治疗方案]]></title>
	      <description><![CDATA[<p><span style="font-size: larger; ">&nbsp;经研究我的痤疮可能是肠胃引起的，</span><a target="_blank" href="http://baike.baidu.com/view/42093.htm#1"><span style="font-size: larger; ">度娘</span></a><span style="font-size: larger; ">如是讲：</span></p>
<p><em><span style="font-size: x-small; ">胃热引起痤疮,宜用清泻胃肠法<br />
胃热痤疮，多由饮食不节，过食肥甘之物，使肠胃燥结,中焦积热，郁于面部皮肤而致。其症面部丘疹,状如粟米，能挤出白粉样油状物,间有黑头粉刺，以口周为多,亦可见于背部与前胸，且常伴有口干口臭,饮食较多，舌燥,喜冷饮，大便秘结,脉沉实有力等。最宜上法。用清胃散 (黄连、升麻、当归、生地、丹皮、石膏 )加减治之，甚验。</span></em></p>
<p><span style="font-size: larger; ">因此决定买入下中西药：</span></p>
<p><strong><span style="color: rgb(153, 204, 0); "><span style="font-size: larger; ">清胃散</span></span></strong><span style="font-size: larger; "> （中药-内服）；</span></p>
<p><span style="color: rgb(153, 204, 0); "><strong><span style="font-size: larger; ">维A酸 系列</span></strong></span><span style="font-size: larger; "> (西药-外用);</span></p>
<p><span style="font-size: larger; ">宜忌：</span></p>
<p><span style="font-size: larger; ">1．精神、心理因素很重要：不要患了痤疮就悲观，要乐观自信，坚持积极、合理的治疗。<br />
2．饮食方面：要注意&ldquo;四少一多&rdquo;，即少吃辛辣食物（如辣椒、葱、蒜等），少吃油腻食物（如动物油、植物油等），少吃甜食（如糖类、咖啡类），少吃&ldquo;发物&rdquo;（如狗、羊肉等），适当吃凉性蔬菜、水果,也防过量后引起胃病。<br />
3．生活方面：最好不吸烟，不喝酒及浓茶等，活动性、炎症性痤疮（如丘疹、脓疮）患者要少晒太阳，避免风沙，太冷、太热、太潮湿的场所也对痤疮不利。</span></p>
<p><span style="font-size: larger; ">注意事项：</span></p>
<p><span style="font-size: larger; ">（1）具有防治痤疮作用的化妆品，常有的成分是硫磺、甘油、氧化铅、水杨酸、苯酚、樟脑、维生素A、维生素E、叶绿素、酒精、聚乙二醇、丙二醇、雌激素、胆固醇、界面活性剂、中草药、凡士林、脂肪酸、抗生素及防腐剂、色素、香料等。据医学界人士分析认为，这类化妆品在某种程度上可起到防治痤疮的作用，但也可能诱发、加重痤疮，甚至可导致接触性皮炎，尤其是长期使用者更应注意。<br />
（2）为扬长避短助美容，痤疮患者可用化妆水、霜剂和乳剂等，及时清洗面部的油性分泌物，防止毛囊及皮脂腺堵塞，不可用油剂和膏剂化妆品。清洗面部、去除化妆物时宜采用洗面奶或普通香皂，但不可用力摩擦和使用按摩乳。为了清除残留在皮肤表面皱纹中的化妆品，以防粉底霜或扑粉中的微颗粒堵塞毛囊皮脂腺口而诱发或加重痤疮，患者可一星期使用一次面膜，但面膜停留面部时间不宜超过20分钟。另外，痤疮患者在化妆美容时，要采用淡妆，尽量减少化妆次数，并缩短化妆品在面部停留的时间，避免化妆品中化学物质对皮肤的刺激。<br />
（3）另一方面，痤疮患者在使用痤疮外用剂的同时，最好每天2~3次用温水、少许洗面奶或香皂清除面部的油脂及尘土、于皮损处涂擦外用剂，待外用剂干燥后，再全面训使用权化妆品，如化妆水、乳液等。痤疮症状较轻者，可使用粉底霜或扑粉，而重症患者或炎症反应较强时应禁止使用粉底霜。同时，痤疮患者应避免使用含有香料的化妆品，谨防香料诱发接触性皮炎。在日常生活中，痤疮患者应力戒烟酒，不食高脂肪、高糖饮食，不多食辛辣、燥热、带刺激性的食物，宜多食蔬菜水果，以期早日康复。</span></p>
<p><span class="Apple-style-span" style="font-size: 14px;"><br />
</span></p>]]></description>
	      <guid isPermaLink="false">beng.name/news/90</guid>
	      <link><![CDATA[http://beng.name/article/atricle-90.html]]></link>
	      <pubDate><![CDATA[2011-11-20 17:09:43]]></pubDate>
	      <author><![CDATA[翟维金]]></author>
	    </item>
		
		<item>
	      <title><![CDATA[发现个不错的自建房网站]]></title>
	      <description><![CDATA[<p>&nbsp;发现一个不错的关于建房的网站，自己盖房子&nbsp;<a target="_blank" href="http://www.zijianfang.cn">自建房的网站</a>，里边有好多有图有真相的过程。能够让你了解<a target="_blank" href="http://www.zijianfang.cn/22831.html">日本人的房子咋那么抗震</a>，<a target="_blank" href="http://www.zijianfang.cn/20249.html">老美的房子</a>怎么好像很便宜但是老被飓风吹走，严谨的<a target="_blank" href="http://www.zijianfang.cn/12157.html">德国人是怎么盖房子的</a>。当然这只是我自己的一点看法，网站内容很丰富自己探索去吧<a target="_blank" href="http://www.zijianfang.cn">http://www.zijianfang.cn</a>。</p>
<p><img alt="德国小住宅" width="500" height="375" title="德国小住宅" src="http://blog.zhulong.com/blogattach/2010/11/17/201011171838164209_80310_big.jpg" /></p>
<p><img alt="美国民宅" width="500" height="332" title="美国民宅" src="http://www.zijianfang.cn/wp-content/uploads/2011/09/1829.jpg" /></p>
<p><img alt="日本人的房子" width="500" height="374" title="日本人的房子" src="http://blog.zhulong.com/blogattach/2011/4/25/201104251648476040_90353.jpg" /></p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 15px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; list-style-type: none; list-style-position: initial; list-style-image: initial; font-size: 14px; line-height: 22px; text-align: left; "><b><br />
</b></div>
<p>&nbsp;</p>]]></description>
	      <guid isPermaLink="false">beng.name/news/88</guid>
	      <link><![CDATA[http://beng.name/article/atricle-88.html]]></link>
	      <pubDate><![CDATA[2011-11-09 12:38:53]]></pubDate>
	      <author><![CDATA[翟维金]]></author>
	    </item>
		
		<item>
	      <title><![CDATA[茶的种类]]></title>
	      <description><![CDATA[<p><span style="font-size: larger; ">对茶孤陋寡闻，因为发现大红袍和铁观音味道类似，所以查了下，粘在这里以后不用找度娘了。</span></p>
<p><span style="font-size: larger; ">茶叶品种繁多，其中中国最多。目前茶叶分类尚未有统一的方法，按照不同的标准有不同的分类方法。其中安徽农业大学陈椽教授提出的按制法和品质为基础，以茶多酚氧化程度为序把初制茶叶分为绿茶、黄茶、黑茶、青茶、白茶、红茶等六大茶类。这种方法已被业界广泛应用。此外，结合茶叶的商品形态可把茶叶分成红茶、绿茶、花茶、乌龙茶、白茶、紧压茶和速溶茶等七大茶类。</span></p>
<p><span style="font-size: larger; ">在国外，茶叶分类比较简单，欧洲把茶叶按商品特性分为红茶、乌龙茶、绿茶三大茶类。日本则按茶叶发酵程度不同分为不发酵茶、半发酵茶、全发酵茶、后发酵茶。</span></p>
<p><span style="color: rgb(255, 153, 0); "><span style="font-size: large; "><em><strong>看了下其实各种分类方法都是和发酵相关的。</strong></em></span></span></p>
<p><strong><span style="color: rgb(0, 255, 0); "><span style="font-size: larger; ">绿茶</span></span></strong><span style="font-size: larger; ">：&nbsp;</span></p>
<p><span style="font-size: larger; ">绿茶是一种不经发酵制成的茶。因其叶片及汤呈绿色，故名。中国绿茶十大名茶是西湖龙井、太湖碧螺春、黄山毛峰、六安瓜片、君山银针、信阳毛尖、太平猴魁、庐山云雾、四川蒙顶、顾渚紫笋茶。&nbsp;</span></p>
<p><span style="color: rgb(255, 0, 0); "><strong><span style="font-size: larger; ">红茶</span></strong></span><span style="font-size: larger; ">：&nbsp;</span></p>
<p><span style="font-size: larger; ">红茶是一种经过发酵制成的茶。因其叶片及汤呈红色，故名。中国著名的红茶有安微祁红、云南镇红、湖北宣红、四川川红。&nbsp;</span></p>
<p><span style="color: rgb(255, 0, 255); "><strong><span style="font-size: larger; ">花茶</span></strong></span><span style="font-size: larger; ">：&nbsp;</span></p>
<p><span style="font-size: larger; ">花茶是成品绿茶之一。将香花放在茶胚中窨制而成。常用的香花有茉莉、珠兰、玳玳、玫瑰、柚花等。以福建、江苏、浙江、安徽、四川为主要产地。苏州茉莉花茶，是花茶中的名品；福建茉莉花茶，属浓香型茶，茶汤醇厚，香味浓烈，汤黄绿，鲜味持久。&nbsp;</span></p>
<p><span style="color: rgb(128, 128, 0); "><strong><span style="font-size: larger; ">乌龙茶</span></strong></span><span style="font-size: larger; ">：&nbsp;</span></p>
<p><span style="font-size: larger; ">乌龙茶是一种半发酵茶，特征是叶片中心为绿色，边缘为红色，俗称绿叶红镶边。主要产于福建、广东、台湾等地。一般以产地的茶树命名，如铁观音、大红袍、乌龙、水仙、单枞等。它有红茶的醇厚，而又比一般红茶涩味浓烈；有绿茶的清爽，而无一般绿茶的涩味，其香气浓烈持久，饮后留香，并具提神、消食、止痢、解暑、醒酒等功效。清初就远销欧美及南洋诸国。目下最受日本游客的欢迎。&nbsp;</span></p>
<p><span style="color: rgb(255, 255, 255); "><strong><span style="font-size: larger; ">白茶</span></strong></span><span style="font-size: larger; ">：&nbsp;</span></p>
<p><span style="font-size: larger; ">白茶是一种不经发酵，亦不经揉捻的茶。具有天然香味，茶分大白、水仙白、山白等类，故名白茶。其中以银针白毫，最为名贵，特点是遍披白色茸毛，并带银色花泽，汤色略黄而滋味甜醇。主要产地在福建福鼎县和政和县。&nbsp;</span></p>
<p><strong><span style="color: rgb(128, 0, 0); "><span style="font-size: larger; ">砖茶</span></span></strong><span style="font-size: larger; ">：&nbsp;</span></p>
<p><span style="font-size: larger; ">砖茶属紧压茶。用绿茶、花茶、老青茶等原料茶经蒸制后放入砖形模具压制而成。主要产于云南、四川、湖南、湖北等地。砖茶又称边销茶，主要销售边疆、牧区等地。</span></p>
<p><span style="font-size: larger; "><br />
</span></p>
<p><span style="font-size: larger; ">各种茶类经历了漫长的发展过程。周朝：茶鲜叶晒干或阴干收藏，与现在白茶制法相同；东汉：茶鲜叶捣碎制成饼茶；唐朝：茶鲜叶先蒸后捣碎，制成团块茶，因技术掌握不同，出现了黄茶、绿茶和黑茶；北宋：发明蒸青散茶；南宋：发明炒青散茶；明朝；发明红茶制法；清朝：发明青茶制法。至此分为绿茶、红茶、青茶（乌龙茶）、白茶、黄茶、黑茶六大类。&nbsp;</span></p>
<p><span style="font-size: larger; ">据不完全统计，全国名优茶多达千种，其中获得省级以上名茶称号的有四百多种。名优绿茶品种最多（产量占名优茶总产量的80%以上，其次是青茶和白茶，在再次为黄茶，黑茶最少。&nbsp;</span></p>
<p><span style="font-size: larger; ">名茶主要形状有扁形、针形、片形、卷曲形、牙形、尖形、圆形、兰花形、条形等九大类）；共同特点是：茶树品种优良，原料细嫩，采摘精细，加工精湛，形质优异，风格独特。</span></p>
<p><span style="font-size: larger; ">&nbsp;</span></p>]]></description>
	      <guid isPermaLink="false">beng.name/news/87</guid>
	      <link><![CDATA[http://beng.name/article/atricle-87.html]]></link>
	      <pubDate><![CDATA[2011-11-07 15:41:12]]></pubDate>
	      <author><![CDATA[翟维金]]></author>
	    </item>
		
		<item>
	      <title><![CDATA[北京市政府煤改电工程低谷电 时间]]></title>
	      <description><![CDATA[<p><span style="font-size: larger; ">&nbsp;马上开始供暖了，集中供暖的11.7号开始预热了，我们煤改电也可以正式享受低谷电了。</span></p>
<p><span style="font-size: larger; ">优惠电价时段设定为每年 11 月 1 日至次年 3月 31 日， 对政府实施煤改电的区域， 享受低谷用电优惠， 低谷时段为晚 22:00至次日早 6:00。</span></p>
<p>&nbsp;</p>
<p>参考文献：<a target="_blank" href="http://wenku.baidu.com/view/d17f17f8770bf78a6529545b.html">http://wenku.baidu.com/view/d17f17f8770bf78a6529545b.html</a></p>]]></description>
	      <guid isPermaLink="false">beng.name/news/86</guid>
	      <link><![CDATA[http://beng.name/article/atricle-86.html]]></link>
	      <pubDate><![CDATA[2011-11-06 23:11:26]]></pubDate>
	      <author><![CDATA[翟维金]]></author>
	    </item>
		
		<item>
	      <title><![CDATA[减少屋内潮气的措施]]></title>
	      <description><![CDATA[<p><span style="font-size: larger; ">&nbsp;最近屋里总是很<span style="color: rgb(0, 204, 255); "><strong>潮</strong></span>，老电脑放几天就濒临over ，衣服摸着像过了水，真是不爽，网上查了查减少潮气的方法。总结一下：</span></p>
<p><span style="font-size: larger; ">1.天气好的时候经常通风。</span></p>
<p><span style="font-size: larger; ">2.不在屋里的各种容器中放水，尤其是大盆里。</span></p>
<p><span style="font-size: larger; ">3.实用各种化学药剂吸潮剂，吸湿，卓越、京东、淘宝等网上有卖。<img alt="吸潮剂" width="300" height="28" title="吸潮剂" src="/userfiles/image/chushiji1.png" /></span></p>
<p><span style="font-size: larger; ">4.将冰箱里冻过的瓶子放到水槽中让它凝结水并自动流走。</span></p>
<p><span style="font-size: larger; ">5.买除湿机或者空调（暂时不考虑）。<img alt="除湿机" width="300" height="29" title="除湿机" src="/userfiles/image/chushiji.png" /></span></p>
<p><span style="font-size: larger; ">6.自己山寨一个。</span></p>]]></description>
	      <guid isPermaLink="false">beng.name/news/85</guid>
	      <link><![CDATA[http://beng.name/article/atricle-85.html]]></link>
	      <pubDate><![CDATA[2011-11-03 17:00:32]]></pubDate>
	      <author><![CDATA[翟维金]]></author>
	    </item>
		
		<item>
	      <title><![CDATA[Beng修复一个bug]]></title>
	      <description><![CDATA[<p>&nbsp;beng的邮件系统存在一个bug，之前的设想是只收最近20封邮件，并且如果这20封里有已经存在的邮件则不再处理了，但是由于编程的时候把continue当成break用了，运行至今发现邮件表特别的大，今天达到了40多M，查了下代码终于发现了，干掉了bug。</p>]]></description>
	      <guid isPermaLink="false">beng.name/news/83</guid>
	      <link><![CDATA[http://beng.name/article/atricle-83.html]]></link>
	      <pubDate><![CDATA[2011-10-28 16:22:30]]></pubDate>
	      <author><![CDATA[翟维金]]></author>
	    </item>
		
  </channel>
</rss>





