PERL与MySQL（三、DBI接口）

答案：通用DBI方法
<TABLE border=1 cellSpacing=1 width=624>
  <TBODY>
  <TR>
    <TD vAlign=center>
      <P align=justify><SPAN class=text1>connect </SPAN></P></TD>
    <TD vAlign=center>
      <P align=justify><SPAN class=text1>建立与一个数据库服务器的连接</SPAN></P></TD></TR>
  <TR>
    <TD vAlign=center>
      <P align=justify><SPAN class=text1>prepare </SPAN></P></TD>
    <TD vAlign=center>
      <P align=justify><SPAN class=text1>获取准备执行的SQL语句</SPAN></P></TD></TR>
  <TR>
    <TD vAlign=center>
      <P align=justify><SPAN class=text1>do </SPAN></P></TD>
    <TD vAlign=center>
      <P align=justify><SPAN class=text1>准备并执行一个SQL语句</SPAN></P></TD></TR>
  <TR>
    <TD vAlign=center>
      <P align=justify><SPAN class=text1>disconnect </SPAN></P></TD>
    <TD vAlign=center>
      <P align=justify><SPAN class=text1>断开与一个数据库服务器的连接</SPAN></P></TD></TR>
  <TR>
    <TD vAlign=center>
      <P align=justify><SPAN class=text1>quote </SPAN></P></TD>
    <TD vAlign=center>
      <P align=justify><SPAN class=text1>被插入引用字符串（块）</SPAN></P></TD></TR>
  <TR>
    <TD vAlign=center>
      <P align=justify><SPAN class=text1>execute </SPAN></P></TD>
    <TD vAlign=center>
      <P align=justify><SPAN class=text1>执行存储过程</SPAN></P></TD></TR>
  <TR>
    <TD vAlign=center>
      <P align=justify><SPAN class=text1>fetchrow_array </SPAN></P></TD>
    <TD vAlign=center>
      <P align=justify><SPAN class=text1>取出下一行到一个数组之中</SPAN></P></TD></TR>
  <TR>
    <TD vAlign=center>
      <P align=justify><SPAN class=text1>fetchrow_arrayref </SPAN></P></TD>
    <TD vAlign=center>
      <P align=justify><SPAN class=text1>取出下一行到数组中，返回数组的引用</SPAN></P></TD></TR>
  <TR>
    <TD vAlign=center>
      <P align=justify><SPAN class=text1>fetchrow_hashref </SPAN></P></TD>
    <TD vAlign=center>
      <P align=justify><SPAN class=text1>取出下一行到哈希表，返回其引用</SPAN></P></TD></TR>
  <TR>
    <TD vAlign=center>
      <P align=justify><SPAN class=text1>fetchall_arrayref </SPAN></P></TD>
    <TD vAlign=center>
      <P align=justify><SPAN class=text1>取出所有的数据到一个数组，返回其引用。</SPAN></P></TD></TR>
  <TR>
    <TD vAlign=center>
      <P align=justify><SPAN class=text1>finish </SPAN></P></TD>
    <TD vAlign=center>
      <P align=justify><SPAN class=text1>结束语句、释放系统资源</SPAN></P></TD></TR>
  <TR>
    <TD vAlign=center>
      <P align=justify><SPAN class=text1>rows </SPAN></P></TD>
    <TD vAlign=center>
      <P align=justify><SPAN class=text1>返回作用的行的数目</SPAN></P></TD></TR>
  <TR>
    <TD vAlign=center>
      <P align=justify><SPAN class=text1>data_sources </SPAN></P></TD>
    <TD vAlign=center>
      <P align=justify><SPAN class=text1>返回本机中可用的数据库的数组。</SPAN></P></TD></TR>
  <TR>
    <TD vAlign=center>
      <P align=justify><SPAN class=text1>ChopBlanks </SPAN></P></TD>
    <TD vAlign=center>
      <P align=justify><SPAN class=text1>去除空格 </SPAN></P></TD></TR>
  <TR>
    <TD vAlign=center>
      <P align=justify><SPAN class=text1>NUM_OF_PARAMS </SPAN></P></TD>
    <TD vAlign=center>
      <P align=justify><SPAN class=text1>存储过程中占位符的数目</SPAN></P></TD></TR>
  <TR>
    <TD vAlign=center>
      <P align=justify><SPAN class=text1>NULLABLE </SPAN></P></TD>
    <TD vAlign=center>
      <P align=justify><SPAN 
class=text1>哪一个行允许Null。</SPAN></P></TD></TR></TBODY></TABLE><STRONG>
<P align=justify><SPAN class=text1>MySQL 的特殊方法</SPAN></P></STRONG>
<TABLE border=1 cellSpacing=1 width=624>
  <TBODY>
  <TR>
    <TD vAlign=center>
      <P align=justify><SPAN class=text1>insertid </SPAN></P></TD>
    <TD vAlign=center>
      <P align=justify><SPAN class=text1>最后自动递增的值</SPAN></P></TD></TR>
  <TR>
    <TD vAlign=center>
      <P align=justify><SPAN class=text1>is_blob </SPAN></P></TD>
    <TD vAlign=center>
      <P align=justify><SPAN class=text1>为BLOB的行</SPAN></P></TD></TR>
  <TR>
    <TD vAlign=center>
      <P align=justify><SPAN class=text1>is_key </SPAN></P>

上一个：尝试用sql查询语句操纵普通文本数据库！使用简单的select就可以实现文本的索引访问，用update……
下一个：Perl的经典用法