manual_function_index.html

详细介绍了MYSQL的主要功能几一些代码

  <li><a href="manual_Clients.html#IDX762"><code>mysql_query()</code></a> </li>
  <li><a href="manual_Clients.html#IDX763"><code>mysql_real_connect()</code></a> </li>
  <li><a href="manual_Clients.html#IDX764"><code>mysql_real_query()</code></a> </li>
  <li><a href="manual_Clients.html#IDX765"><code>mysql_reload()</code></a> </li>
  <li><a href="manual_Clients.html#IDX717">MYSQL_RES C type</a> </li>
  <li><a href="manual_Clients.html#IDX718">MYSQL_ROW C type</a> </li>
  <li><a href="manual_Clients.html#IDX766"><code>mysql_row_seek()</code></a> </li>
  <li><a href="manual_Clients.html#IDX767"><code>mysql_row_tell()</code></a> </li>
  <li><a href="manual_Clients.html#IDX768"><code>mysql_select_db()</code></a> </li>
  <li><a href="manual_Clients.html#IDX769"><code>mysql_shutdown()</code></a> </li>
  <li><a href="manual_Clients.html#IDX770"><code>mysql_stat()</code></a> </li>
  <li><a href="manual_Clients.html#IDX771"><code>mysql_store_result()</code></a> </li>
  <li><a href="manual_Installing.html#IDX91">MYSQL_TCP_PORT environment variable</a>, <a
    href="manual_Tools.html#IDX642">MYSQL_TCP_PORT environment variable</a>, <a
    href="manual_Common_problems.html#IDX712">MYSQL_TCP_PORT environment variable</a> </li>
  <li><a href="manual_Clients.html#IDX772"><code>mysql_thread_id()</code></a> </li>
  <li><a href="manual_Installing.html#IDX90">MYSQL_UNIX_PORT environment variable</a>, <a
    href="manual_Installing.html#IDX95">MYSQL_UNIX_PORT environment variable</a>, <a
    href="manual_Tools.html#IDX640">MYSQL_UNIX_PORT environment variable</a>, <a
    href="manual_Common_problems.html#IDX711">MYSQL_UNIX_PORT environment variable</a> </li>
  <li><a href="manual_Clients.html#IDX773"><code>mysql_use_result()</code></a> </li>
</dir>

<h2>N</h2>

<dir>
  <li><a href="manual_Clients.html#IDX831">NAME DBI method</a> </li>
  <li><a href="manual_Reference.html#IDX221">NATIONAL CHAR</a> </li>
  <li><a href="manual_Reference.html#IDX532">NATURAL LEFT JOIN</a> </li>
  <li><a href="manual_Reference.html#IDX533">NATURAL LEFT OUTER JOIN</a> </li>
  <li><a href="manual_Reference.html#IDX222">NCHAR</a> </li>
  <li><a href="manual_Reference.html#IDX158">newline (\n)</a> </li>
  <li><a href="manual_Reference.html#IDX304">not equal (!=)</a> </li>
  <li><a href="manual_Reference.html#IDX302">not equal (&lt;&gt;)</a> </li>
  <li><a href="manual_Reference.html#IDX318">NOT IN</a> </li>
  <li><a href="manual_Reference.html#IDX327">NOT LIKE</a> </li>
  <li><a href="manual_Reference.html#IDX332">NOT REGEXP</a> </li>
  <li><a href="manual_Reference.html#IDX288">NOT, logical</a> </li>
  <li><a href="manual_Reference.html#IDX451">NOW()</a> </li>
  <li><a href="manual_Reference.html#IDX156">NUL</a> </li>
  <li><a href="manual_Problems.html#IDX698">NULL</a> </li>
  <li><a href="manual_Reference.html#IDX182">NULL value</a> </li>
  <li><a href="manual_Clients.html#IDX802">NULLABLE DBI method</a> </li>
  <li><a href="manual_Clients.html#IDX804">NUM_OF_FIELDS DBI method</a> </li>
  <li><a href="manual_Reference.html#IDX215">NUMERIC</a> </li>
</dir>

<h2>O</h2>

<dir>
  <li><a href="manual_Reference.html#IDX382">OCT()</a> </li>
  <li><a href="manual_Reference.html#IDX387">OCTET_LENGTH()</a> </li>
  <li><a href="manual_Reference.html#IDX517">OPTIMIZE TABLE</a> </li>
  <li><a href="manual_Reference.html#IDX279">OR, bitwise</a> </li>
  <li><a href="manual_Reference.html#IDX290">OR, logical</a> </li>
  <li><a href="manual_Reference.html#IDX379">ORD()</a> </li>
</dir>

<h2>P</h2>

<dir>
  <li><a href="manual_Reference.html#IDX264">parentheses ( and )</a> </li>
  <li><a href="manual_Privilege_system.html#IDX132">PASSWORD()</a>, <a
    href="manual_Privilege_system.html#IDX147">PASSWORD()</a>, <a
    href="manual_Reference.html#IDX465">PASSWORD()</a>, <a href="manual_Problems.html#IDX685">PASSWORD()</a> 
  </li>
  <li><a href="manual_Installing.html#IDX39">PATH environment variable</a> </li>
  <li><a href="manual_Reference.html#IDX436">PERIOD_ADD()</a> </li>
  <li><a href="manual_Reference.html#IDX437">PERIOD_DIFF()</a> </li>
  <li><a href="manual_Reference.html#IDX361">PI()</a> </li>
  <li><a href="manual_Reference.html#IDX391">POSITION()</a> </li>
  <li><a href="manual_Reference.html#IDX358">POW()</a> </li>
  <li><a href="manual_Reference.html#IDX359">POWER()</a> </li>
  <li><a href="manual_Clients.html#IDX780">prepare() DBI method</a> </li>
  <li><a href="manual_Reference.html#IDX567">PROCESSLIST</a> </li>
</dir>

<h2>Q</h2>

<dir>
  <li><a href="manual_Reference.html#IDX430">QUARTER()</a> </li>
  <li><a href="manual_Clients.html#IDX786">quote() DBI method</a> </li>
  <li><a href="manual_Reference.html#IDX183">Quoting of identifiers</a> </li>
</dir>

<h2>R</h2>

<dir>
  <li><a href="manual_Reference.html#IDX374">RADIANS()</a> </li>
  <li><a href="manual_Reference.html#IDX370">RAND()</a> </li>
  <li><a href="manual_Reference.html#IDX213">REAL</a> </li>
  <li><a href="manual_Reference.html#IDX330">REGEXP</a> </li>
  <li><a href="manual_Reference.html#IDX476">RELEASE_LOCK()</a> </li>
  <li><a href="manual_Reference.html#IDX408">REPEAT()</a> </li>
  <li><a href="manual_Reference.html#IDX541">REPLACE</a> </li>
  <li><a href="manual_Reference.html#IDX407">REPLACE()</a> </li>
  <li><a href="manual_Reference.html#IDX162">return (\r)</a> </li>
  <li><a href="manual_Reference.html#IDX409">REVERSE()</a> </li>
  <li><a href="manual_Reference.html#IDX585">REVOKE</a> </li>
  <li><a href="manual_Reference.html#IDX397">RIGHT()</a> </li>
  <li><a href="manual_Reference.html#IDX331">RLIKE</a> </li>
  <li><a href="manual_Reference.html#IDX353">ROUND()</a>, <a
    href="manual_Reference.html#IDX354">ROUND()</a> </li>
  <li><a href="manual_Clients.html#IDX800">rows DBI method</a> </li>
  <li><a href="manual_Reference.html#IDX395">RPAD()</a> </li>
  <li><a href="manual_Reference.html#IDX403">RTRIM()</a> </li>
</dir>

<h2>S</h2>

<dir>
  <li><a href="manual_Reference.html#IDX457">SEC_TO_TIME()</a> </li>
  <li><a href="manual_Reference.html#IDX435">SECOND()</a> </li>
  <li><a href="manual_Reference.html#IDX520">SELECT</a> </li>
  <li><a href="manual_Reference.html#IDX569">SELECT, optimizing</a> </li>
  <li><a href="manual_Reference.html#IDX464">SESSION_USER()</a> </li>
  <li><a href="manual_Reference.html#IDX237">SET</a>, <a href="manual_Reference.html#IDX255">SET</a> 
  </li>
  <li><a href="manual_Reference.html#IDX580">SET OPTION</a> </li>
  <li><a href="manual_Reference.html#IDX556">SHOW COLUMNS</a> </li>
  <li><a href="manual_Reference.html#IDX554">SHOW DATABASES</a> </li>
  <li><a href="manual_Reference.html#IDX557">SHOW FIELDS</a> </li>
  <li><a href="manual_Reference.html#IDX564">SHOW GRANTS</a> </li>
  <li><a href="manual_Reference.html#IDX558">SHOW INDEX</a> </li>
  <li><a href="manual_Reference.html#IDX559">SHOW KEYS</a> </li>
  <li><a href="manual_Reference.html#IDX562">SHOW PROCESSLIST</a> </li>
  <li><a href="manual_Reference.html#IDX560">SHOW STATUS</a> </li>
  <li><a href="manual_Reference.html#IDX563">SHOW TABLE STATUS</a> </li>
  <li><a href="manual_Reference.html#IDX555">SHOW TABLES</a> </li>
  <li><a href="manual_Reference.html#IDX561">SHOW VARIABLES</a> </li>
  <li><a href="manual_Reference.html#IDX347">SIGN()</a> </li>
  <li><a href="manual_Reference.html#IDX363">SIN()</a> </li>
  <li><a href="manual_Reference.html#IDX167">single quote (\')</a> </li>
  <li><a href="manual_Reference.html#IDX198">SMALLINT</a> </li>
  <li><a href="manual_Reference.html#IDX405">SOUNDEX()</a> </li>
  <li><a href="manual_Reference.html#IDX406">SPACE()</a> </li>
  <li><a href="manual_Reference.html#IDX360">SQRT()</a> </li>
  <li><a href="manual_Reference.html#IDX487">STD()</a> </li>
  <li><a href="manual_Reference.html#IDX488">STDDEV()</a> </li>
  <li><a href="manual_Reference.html#IDX534">STRAIGHT_JOIN</a> </li>
  <li><a href="manual_Reference.html#IDX333">STRCMP()</a> </li>
  <li><a href="manual_Reference.html#IDX322">String comparison functions</a> </li>
  <li><a href="manual_Reference.html#IDX376">String functions</a> </li>
  <li><a href="manual_Reference.html#IDX441">SUBDATE()</a> </li>
  <li><a href="manual_Reference.html#IDX398">SUBSTRING()</a>, <a
    href="manual_Reference.html#IDX400">SUBSTRING()</a> </li>
  <li><a href="manual_Reference.html#IDX401">SUBSTRING_INDEX()</a> </li>
  <li><a href="manual_Reference.html#IDX269">subtraction (-)</a> </li>
  <li><a href="manual_Reference.html#IDX486">SUM()</a> </li>
  <li><a href="manual_Reference.html#IDX452">SYSDATE()</a> </li>
  <li><a href="manual_Reference.html#IDX463">SYSTEM_USER()</a> </li>
</dir>

<h2>T</h2>

<dir>
  <li><a href="manual_Reference.html#IDX160">tab (\t)</a> </li>
  <li><a href="manual_Clients.html#IDX833">table DBI method</a> </li>
  <li><a href="manual_Performance.html#IDX622">table_cache</a> </li>
  <li><a href="manual_Reference.html#IDX364">TAN()</a> </li>
  <li><a href="manual_Reference.html#IDX231">TEXT</a>, <a href="manual_Reference.html#IDX250">TEXT</a> 
  </li>
  <li><a href="manual_Reference.html#IDX566">Threads</a> </li>
  <li><a href="manual_Reference.html#IDX219">TIME</a>, <a href="manual_Reference.html#IDX245">TIME</a> 
  </li>
  <li><a href="manual_Reference.html#IDX446">TIME_FORMAT()</a> </li>
  <li><a href="manual_Reference.html#IDX458">TIME_TO_SEC()</a> </li>
  <li><a href="manual_Reference.html#IDX218">TIMESTAMP</a>, <a
    href="manual_Reference.html#IDX244">TIMESTAMP</a> </li>
  <li><a href="manual_Reference.html#IDX228">TINYBLOB</a> </li>
  <li><a href="manual_Reference.html#IDX197">TINYINT</a> </li>
  <li><a href="manual_Reference.html#IDX229">TINYTEXT</a> </li>
  <li><a href="manual_Installing.html#IDX94">TMPDIR environment variable</a> </li>
  <li><a href="manual_Reference.html#IDX443">TO_DAYS()</a> </li>
  <li><a href="manual_Clients.html#IDX810">trace DBI method</a>, <a
    href="manual_Porting.html#IDX840">trace DBI method</a> </li>
  <li><a href="manual_Reference.html#IDX404">TRIM()</a> </li>
  <li><a href="manual_Reference.html#IDX375">TRUNCATE()</a> </li>
  <li><a href="manual_Clients.html#IDX835">type DBI method</a> </li>
  <li><a href="manual_Reference.html#IDX196">Types</a> </li>
  <li><a href="manual_Installing.html#IDX83">TZ environment variable</a>, <a
    href="manual_Installing.html#IDX86">TZ environment variable</a>, <a
    href="manual_Problems.html#IDX692">TZ environment variable</a> </li>
</dir>

<h2>U</h2>

<dir>
  <li><a href="manual_Reference.html#IDX418">UCASE()</a> </li>
  <li><a href="manual_Reference.html#IDX596">UDF functions</a> </li>
  <li><a href="manual_Problems.html#IDX690">ulimit</a> </li>
  <li><a href="manual_Problems.html#IDX688">UMASK environment variable</a> </li>
  <li><a href="manual_Reference.html#IDX345">unary minus (-)</a> </li>
  <li><a href="manual_Reference.html#IDX454">UNIX_TIMESTAMP()</a> </li>
  <li><a href="manual_Reference.html#IDX579">UNLOCK TABLES</a> </li>
  <li><a href="manual_Reference.html#IDX545">UPDATE</a> </li>
  <li><a href="manual_Reference.html#IDX419">UPPER()</a> </li>
  <li><a href="manual_Reference.html#IDX547">USE</a> </li>
  <li><a href="manual_Privilege_system.html#IDX125">USER environment variable</a> </li>
  <li><a href="manual_Reference.html#IDX462">USER()</a> </li>
  <li><a href="manual_Reference.html#IDX597">User-defined functions</a> </li>
</dir>

<h2>V</h2>

<dir>
  <li><a href="manual_Reference.html#IDX227">VARCHAR</a>, <a
    href="manual_Reference.html#IDX248">VARCHAR</a> </li>
  <li><a href="manual_Reference.html#IDX474">VERSION()</a> </li>
</dir>

<h2>W</h2>

<dir>
  <li><a href="manual_Reference.html#IDX431">WEEK()</a> </li>
  <li><a href="manual_Reference.html#IDX424">WEEKDAY()</a> </li>
  <li><a href="manual_Reference.html#IDX173">Wildcard character (%)</a> </li>
  <li><a href="manual_Reference.html#IDX175">Wildcard character (_)</a> </li>
</dir>

<h2>Y</h2>

<dir>
  <li><a href="manual_Reference.html#IDX220">YEAR</a>, <a href="manual_Reference.html#IDX246">YEAR</a> 
  </li>
  <li><a href="manual_Reference.html#IDX432">YEAR()</a> </li>
</dir>

<dir>
  <li><a href="manual_Reference.html#IDX278">| (bitwise OR)</a> </li>
  <li><a href="manual_Reference.html#IDX291">|| (logical OR)</a> </li>
  <li><a href="manual_Reference.html#IDX284">~</a> </li>
</dir>

<hr>

<p>Go to the <a href="manual_Introduction.html">first</a>, <a
href="manual_Win_license.html">previous</a>, <a href="manual_Concept_Index.html">next</a>, 
<a href="manual_Concept_Index.html">last</a> section, <a href="manual_toc.html">table of 
contents</a>. </p>
</body>
</html>