manual_function_index.html

这是一部完整的MYSQL中文参考手册,里面详尽的介绍了MYSQL的使用方法.

  <li><a href="manual_Clients.html#IDX812">Environment variable, DBI_TRACE</a>, <a
    href="manual_Porting.html#IDX842">Environment variable, DBI_TRACE</a> </li>
  <li><a href="manual_Tools.html#IDX651">Environment variable, HOME</a> </li>
  <li><a href="manual_Installing.html#IDX77">Environment variable, LD_RUN_PATH</a>, <a
    href="manual_Installing.html#IDX79">Environment variable, LD_RUN_PATH</a>, <a
    href="manual_Installing.html#IDX81">Environment variable, LD_RUN_PATH</a> </li>
  <li><a href="manual_Tools.html#IDX647">Environment variable, MYSQL_DEBUG</a>, <a
    href="manual_Porting.html#IDX844">Environment variable, MYSQL_DEBUG</a> </li>
  <li><a href="manual_Tools.html#IDX649">Environment variable, MYSQL_HISTFILE</a> </li>
  <li><a href="manual_Privilege_system.html#IDX122">Environment variable, MYSQL_HOST</a> </li>
  <li><a href="manual_Privilege_system.html#IDX124">Environment variable, MYSQL_PWD</a>, <a
    href="manual_Tools.html#IDX645">Environment variable, MYSQL_PWD</a> </li>
  <li><a href="manual_Installing.html#IDX93">Environment variable, MYSQL_TCP_PORT</a>, <a
    href="manual_Tools.html#IDX643">Environment variable, MYSQL_TCP_PORT</a>, <a
    href="manual_Common_problems.html#IDX714">Environment variable, MYSQL_TCP_PORT</a> </li>
  <li><a href="manual_Installing.html#IDX92">Environment variable, MYSQL_UNIX_PORT</a>, <a
    href="manual_Installing.html#IDX97">Environment variable, MYSQL_UNIX_PORT</a>, <a
    href="manual_Tools.html#IDX641">Environment variable, MYSQL_UNIX_PORT</a>, <a
    href="manual_Common_problems.html#IDX713">Environment variable, MYSQL_UNIX_PORT</a> </li>
  <li><a href="manual_Installing.html#IDX40">Environment variable, PATH</a> </li>
  <li><a href="manual_Installing.html#IDX96">Environment variable, TMPDIR</a> </li>
  <li><a href="manual_Installing.html#IDX84">Environment variable, TZ</a>, <a
    href="manual_Installing.html#IDX87">Environment variable, TZ</a>, <a
    href="manual_Problems.html#IDX693">Environment variable, TZ</a> </li>
  <li><a href="manual_Problems.html#IDX689">Environment variable, UMASK</a> </li>
  <li><a href="manual_Privilege_system.html#IDX126">Environment variable, USER</a> </li>
  <li><a href="manual_Installing.html#IDX63">Environment variables, CXX</a> </li>
  <li><a href="manual_Reference.html#IDX300">equal (=)</a> </li>
  <li><a href="manual_Reference.html#IDX171">escape (\\)</a> </li>
  <li><a href="manual_Clients.html#IDX782">execute DBI method</a> </li>
  <li><a href="manual_Reference.html#IDX355">EXP()</a> </li>
  <li><a href="manual_Reference.html#IDX568">EXPLAIN</a> </li>
  <li><a href="manual_Reference.html#IDX415">EXPORT_SET()</a> </li>
  <li><a href="manual_Reference.html#IDX442">EXTRACT(type FROM date)</a> </li>
</dir>

<h2>F</h2>

<dir>
  <li><a href="manual_Clients.html#IDX796">fetchall_arrayref DBI method</a> </li>
  <li><a href="manual_Clients.html#IDX790">fetchrow_array DBI method</a> </li>
  <li><a href="manual_Clients.html#IDX792">fetchrow_arrayref DBI method</a> </li>
  <li><a href="manual_Clients.html#IDX794">fetchrow_hashref DBI method</a> </li>
  <li><a href="manual_Reference.html#IDX412">FIELD()</a> </li>
  <li><a href="manual_Reference.html#IDX420">FILE</a> </li>
  <li><a href="manual_Reference.html#IDX413">FIND_IN_SET()</a> </li>
  <li><a href="manual_Clients.html#IDX798">finish DBI method</a> </li>
  <li><a href="manual_Reference.html#IDX203">FLOAT</a>, <a href="manual_Reference.html#IDX207">FLOAT</a> 
  </li>
  <li><a href="manual_Reference.html#IDX209">FLOAT(M,D)</a> </li>
  <li><a href="manual_Reference.html#IDX208">FLOAT(precision)</a>, <a
    href="manual_Reference.html#IDX211">FLOAT(precision)</a> </li>
  <li><a href="manual_Reference.html#IDX204">FLOAT(precision) [ZEROFILL]</a> </li>
  <li><a href="manual_Reference.html#IDX351">FLOOR()</a> </li>
  <li><a href="manual_Reference.html#IDX551">FLUSH</a> </li>
  <li><a href="manual_Reference.html#IDX473">FORMAT()</a> </li>
  <li><a href="manual_Reference.html#IDX444">FROM_DAYS()</a> </li>
  <li><a href="manual_Reference.html#IDX455">FROM_UNIXTIME()</a>, <a
    href="manual_Reference.html#IDX456">FROM_UNIXTIME()</a> </li>
  <li><a href="manual_Reference.html#IDX276">Functions, arithmetic</a> </li>
  <li><a href="manual_Reference.html#IDX277">Functions, bit</a> </li>
  <li><a href="manual_Reference.html#IDX337">Functions, control flow</a> </li>
  <li><a href="manual_Reference.html#IDX422">Functions, date and time</a> </li>
  <li><a href="manual_Reference.html#IDX479">Functions, GROUP BY</a> </li>
  <li><a href="manual_Reference.html#IDX287">Functions, logical</a> </li>
  <li><a href="manual_Reference.html#IDX342">Functions, mathematical</a> </li>
  <li><a href="manual_Reference.html#IDX460">Functions, miscellaneous</a> </li>
  <li><a href="manual_Reference.html#IDX377">Functions, string</a> </li>
  <li><a href="manual_Reference.html#IDX323">Functions, string comparison</a> </li>
  <li><a href="manual_Reference.html#IDX598">Functions, user-defined</a> </li>
</dir>

<h2>G</h2>

<dir>
  <li><a href="manual_Reference.html#IDX475">GET_LOCK()</a> </li>
  <li><a href="manual_Reference.html#IDX584">GRANT</a> </li>
  <li><a href="manual_Reference.html#IDX312">greater than (&gt;)</a> </li>
  <li><a href="manual_Reference.html#IDX310">greater than or equal (&gt;=)</a> </li>
  <li><a href="manual_Reference.html#IDX372">GREATEST()</a> </li>
  <li><a href="manual_Reference.html#IDX478">GROUP BY functions</a> </li>
</dir>

<h2>H</h2>

<dir>
  <li><a href="manual_Reference.html#IDX383">HEX()</a> </li>
  <li><a href="manual_Reference.html#IDX181">Hexadecimal values</a> </li>
  <li><a href="manual_Tools.html#IDX650">HOME environment variable</a> </li>
  <li><a href="manual_Installing.html#IDX89">host.frm, problems finding</a> </li>
  <li><a href="manual_Reference.html#IDX433">HOUR()</a> </li>
</dir>

<h2>I</h2>

<dir>
  <li><a href="manual_Reference.html#IDX339">IF()</a> </li>
  <li><a href="manual_Reference.html#IDX338">IFNULL()</a> </li>
  <li><a href="manual_Reference.html#IDX317">IN</a> </li>
  <li><a href="manual_Reference.html#IDX528">INNER JOIN</a> </li>
  <li><a href="manual_Reference.html#IDX537">INSERT</a> </li>
  <li><a href="manual_Reference.html#IDX539">INSERT DELAYED</a> </li>
  <li><a href="manual_Reference.html#IDX410">INSERT()</a> </li>
  <li><a href="manual_Clients.html#IDX814">insertid DBI method</a> </li>
  <li><a href="manual_Reference.html#IDX393">INSTR()</a> </li>
  <li><a href="manual_Reference.html#IDX200">INT</a> </li>
  <li><a href="manual_Reference.html#IDX201">INTEGER</a> </li>
  <li><a href="manual_Reference.html#IDX321">INTERVAL()</a> </li>
  <li><a href="manual_Reference.html#IDX315">IS NOT NULL</a> </li>
  <li><a href="manual_Reference.html#IDX314">IS NULL</a> </li>
  <li><a href="manual_Performance.html#IDX630">IS NULL, and indexes</a> </li>
  <li><a href="manual_Clients.html#IDX817">is_blob DBI method</a> </li>
  <li><a href="manual_Clients.html#IDX819">is_key DBI method</a> </li>
  <li><a href="manual_Clients.html#IDX825">is_not_null DBI method</a> </li>
  <li><a href="manual_Clients.html#IDX821">is_num DBI method</a> </li>
  <li><a href="manual_Clients.html#IDX823">is_pri_key DBI method</a> </li>
  <li><a href="manual_Reference.html#IDX319">ISNULL()</a> </li>
</dir>

<h2>J</h2>

<dir>
  <li><a href="manual_Reference.html#IDX527">JOIN</a> </li>
</dir>

<h2>K</h2>

<dir>
  <li><a href="manual_Reference.html#IDX553">KILL</a> </li>
</dir>

<h2>L</h2>

<dir>
  <li><a href="manual_Compatibility.html#IDX118">LAST_INSERT_ID()</a> </li>
  <li><a href="manual_Reference.html#IDX471">LAST_INSERT_ID([expr])</a> </li>
  <li><a href="manual_Reference.html#IDX416">LCASE()</a> </li>
  <li><a href="manual_Installing.html#IDX76">LD_RUN_PATH environment variable</a>, <a
    href="manual_Installing.html#IDX78">LD_RUN_PATH environment variable</a>, <a
    href="manual_Installing.html#IDX80">LD_RUN_PATH environment variable</a> </li>
  <li><a href="manual_Reference.html#IDX371">LEAST()</a> </li>
  <li><a href="manual_Reference.html#IDX530">LEFT JOIN</a> </li>
  <li><a href="manual_Reference.html#IDX531">LEFT OUTER JOIN</a> </li>
  <li><a href="manual_Reference.html#IDX396">LEFT()</a> </li>
  <li><a href="manual_Clients.html#IDX827">length DBI method</a> </li>
  <li><a href="manual_Reference.html#IDX386">LENGTH()</a> </li>
  <li><a href="manual_Reference.html#IDX308">less than (&lt;)</a> </li>
  <li><a href="manual_Reference.html#IDX306">less than or equal (&lt;=)</a> </li>
  <li><a href="manual_Reference.html#IDX326">LIKE</a> </li>
  <li><a href="manual_Performance.html#IDX626">LIKE, and indexes</a> </li>
  <li><a href="manual_Performance.html#IDX627">LIKE, and wildcards</a> </li>
  <li><a href="manual_Reference.html#IDX542">LOAD DATA INFILE</a>, <a
    href="manual_Problems.html#IDX699">LOAD DATA INFILE</a> </li>
  <li><a href="manual_Reference.html#IDX390">LOCATE()</a>, <a
    href="manual_Reference.html#IDX392">LOCATE()</a> </li>
  <li><a href="manual_Reference.html#IDX578">LOCK TABLES</a> </li>
  <li><a href="manual_Reference.html#IDX356">LOG()</a> </li>
  <li><a href="manual_Reference.html#IDX357">LOG10()</a> </li>
  <li><a href="manual_Reference.html#IDX286">Logical functions</a> </li>
  <li><a href="manual_Reference.html#IDX234">LONGBLOB</a> </li>
  <li><a href="manual_Reference.html#IDX235">LONGTEXT</a> </li>
  <li><a href="manual_Reference.html#IDX417">LOWER()</a> </li>
  <li><a href="manual_Reference.html#IDX394">LPAD()</a> </li>
  <li><a href="manual_Reference.html#IDX402">LTRIM()</a> </li>
</dir>

<h2>M</h2>

<dir>
  <li><a href="manual_Reference.html#IDX414">MAKE_SET()</a> </li>
  <li><a href="manual_Reference.html#IDX341">Mathematical functions</a> </li>
  <li><a href="manual_Reference.html#IDX485">MAX()</a> </li>
  <li><a href="manual_Clients.html#IDX829">max_length DBI method</a> </li>
  <li><a href="manual_Reference.html#IDX470">MD5()</a> </li>
  <li><a href="manual_Reference.html#IDX232">MEDIUMBLOB</a> </li>
  <li><a href="manual_Reference.html#IDX199">MEDIUMINT</a> </li>
  <li><a href="manual_Reference.html#IDX233">MEDIUMTEXT</a> </li>
  <li><a href="manual_Reference.html#IDX399">MID()</a> </li>
  <li><a href="manual_Reference.html#IDX484">MIN()</a> </li>
  <li><a href="manual_Reference.html#IDX344">minus, unary (-)</a> </li>
  <li><a href="manual_Reference.html#IDX434">MINUTE()</a> </li>
  <li><a href="manual_Reference.html#IDX459">Miscellaneous functions</a> </li>
  <li><a href="manual_Reference.html#IDX348">MOD()</a> </li>
  <li><a href="manual_Reference.html#IDX350">modulo (%)</a> </li>
  <li><a href="manual_Reference.html#IDX427">MONTH()</a> </li>
  <li><a href="manual_Reference.html#IDX429">MONTHNAME()</a> </li>
  <li><a href="manual_Reference.html#IDX271">multiplication (*)</a> </li>
  <li><a href="manual_Clients.html#IDX721">my_ulonglong C type</a> </li>
  <li><a href="manual_Clients.html#IDX722">my_ulonglong values, printing</a> </li>
  <li><a href="manual_Clients.html#IDX716">MYSQL C type</a> </li>
  <li><a href="manual_Clients.html#IDX723"><code>mysql_affected_rows()</code></a> </li>
  <li><a href="manual_Clients.html#IDX726"><code>mysql_change_user()</code></a> </li>
  <li><a href="manual_Clients.html#IDX724"><code>mysql_close()</code></a> </li>
  <li><a href="manual_Clients.html#IDX725"><code>mysql_connect()</code></a> </li>
  <li><a href="manual_Clients.html#IDX727"><code>mysql_create_db()</code></a> </li>
  <li><a href="manual_Clients.html#IDX728"><code>mysql_data_seek()</code></a> </li>
  <li><a href="manual_Tools.html#IDX646">MYSQL_DEBUG environment variable</a>, <a
    href="manual_Porting.html#IDX843">MYSQL_DEBUG environment variable</a> </li>
  <li><a href="manual_Clients.html#IDX729"><code>mysql_debug()</code></a> </li>
  <li><a href="manual_Clients.html#IDX730"><code>mysql_drop_db()</code></a> </li>
  <li><a href="manual_Clients.html#IDX731"><code>mysql_dump_debug_info()</code></a> </li>
  <li><a href="manual_Clients.html#IDX732"><code>mysql_eof()</code></a> </li>
  <li><a href="manual_Clients.html#IDX733"><code>mysql_errno()</code></a> </li>
  <li><a href="manual_Clients.html#IDX734"><code>mysql_error()</code></a> </li>
  <li><a href="manual_Reference.html#IDX179">mysql_escape_string()</a> </li>
  <li><a href="manual_Clients.html#IDX735"><code>mysql_escape_string()</code></a> </li>
  <li><a href="manual_Clients.html#IDX736"><code>mysql_fetch_field()</code></a> </li>
  <li><a href="manual_Clients.html#IDX738"><code>mysql_fetch_field_direct()</code></a> </li>
  <li><a href="manual_Clients.html#IDX737"><code>mysql_fetch_fields()</code></a> </li>
  <li><a href="manual_Clients.html#IDX739"><code>mysql_fetch_lengths()</code></a> </li>
  <li><a href="manual_Clients.html#IDX740"><code>mysql_fetch_row()</code></a> </li>
  <li><a href="manual_Clients.html#IDX719">MYSQL_FIELD C type</a> </li>
  <li><a href="manual_Clients.html#IDX741"><code>mysql_field_count()</code></a>, <a
    href="manual_Clients.html#IDX758"><code>mysql_field_count()</code></a> </li>
  <li><a href="manual_Clients.html#IDX720">MYSQL_FIELD_OFFSET C type</a> </li>
  <li><a href="manual_Clients.html#IDX742"><code>mysql_field_seek()</code></a> </li>
  <li><a href="manual_Clients.html#IDX743"><code>mysql_field_tell()</code></a> </li>
  <li><a href="manual_Clients.html#IDX744"><code>mysql_free_result()</code></a> </li>
  <li><a href="manual_Clients.html#IDX745"><code>mysql_get_client_info()</code></a> </li>
  <li><a href="manual_Clients.html#IDX746"><code>mysql_get_host_info()</code></a> </li>
  <li><a href="manual_Clients.html#IDX747"><code>mysql_get_proto_info()</code></a> </li>
  <li><a href="manual_Clients.html#IDX748"><code>mysql_get_server_info()</code></a> </li>
  <li><a href="manual_Tools.html#IDX648">MYSQL_HISTFILE environment variable</a> </li>
  <li><a href="manual_Privilege_system.html#IDX121">MYSQL_HOST environment variable</a> </li>
  <li><a href="manual_Reference.html#IDX514">mysql_info()</a>, <a
    href="manual_Reference.html#IDX538">mysql_info()</a>, <a
    href="manual_Reference.html#IDX544">mysql_info()</a>, <a
    href="manual_Reference.html#IDX546">mysql_info()</a> </li>
  <li><a href="manual_Clients.html#IDX749"><code>mysql_info()</code></a> </li>
  <li><a href="manual_Clients.html#IDX750"><code>mysql_init()</code></a> </li>
  <li><a href="manual_Clients.html#IDX751"><code>mysql_insert_id()</code></a> </li>
  <li><a href="manual_Compatibility.html#IDX117">mysql_insert_id()</a> </li>
  <li><a href="manual_Clients.html#IDX752"><code>mysql_kill()</code></a> </li>
  <li><a href="manual_Clients.html#IDX753"><code>mysql_list_dbs()</code></a> </li>
  <li><a href="manual_Clients.html#IDX754"><code>mysql_list_fields()</code></a> </li>
  <li><a href="manual_Clients.html#IDX755"><code>mysql_list_processes()</code></a> </li>
  <li><a href="manual_Clients.html#IDX756"><code>mysql_list_tables()</code></a> </li>
  <li><a href="manual_Clients.html#IDX757"><code>mysql_num_fields()</code></a> </li>
  <li><a href="manual_Clients.html#IDX759"><code>mysql_num_rows()</code></a> </li>
  <li><a href="manual_Clients.html#IDX760"><code>mysql_options()</code></a> </li>
  <li><a href="manual_Clients.html#IDX761"><code>mysql_ping()</code></a> </li>
  <li><a href="manual_Privilege_system.html#IDX123">MYSQL_PWD environment variable</a>, <a
    href="manual_Tools.html#IDX644">MYSQL_PWD environment variable</a> </li>