📄 manual_function_index.html
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<!-- saved from url=(0081)manual_Function_Index.html -->
<html>
<head>
<title>MySQL Reference Manual for version 3.23.7-alpha. - SQL command, type and function
index</title>
<meta content="text/html; charset=gb2312" http-equiv="Content-Type">
<!-- This HTML file has been created by texi2html 1.52 (hacked by david@detron.se)
from /dr1/my/masters/mysql-3.23/Docs/manual.texi on 9 December 1999 -->
<meta content="Microsoft FrontPage 3.0" name="GENERATOR">
</head>
<body bgColor="#ffffff" link="#101090" text="#000000" vLink="#7030b0">
<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>
<hr>
<h1><a href="manual_toc.html#Function_Index" name="Function_Index">SQL command, type and
function index</a></h1>
<dir>
<li><a href="manual_Reference.html#IDX289">! (logical NOT)</a> </li>
<li><a href="manual_Reference.html#IDX303">!= (not equal)</a> </li>
<li><a href="manual_Reference.html#IDX185">"</a> </li>
<li><a href="manual_Reference.html#IDX349">% (modulo)</a> </li>
<li><a href="manual_Reference.html#IDX172">% (wildcard character)</a> </li>
<li><a href="manual_Reference.html#IDX280">& (bitwise AND)</a> </li>
<li><a href="manual_Reference.html#IDX293">&& (logical AND)</a> </li>
<li><a href="manual_Reference.html#IDX263">() (parentheses)</a> </li>
<li><a href="manual_Reference.html#IDX270">* (multiplication)</a> </li>
<li><a href="manual_Reference.html#IDX266">+ (addition)</a> </li>
<li><a href="manual_Reference.html#IDX268">- (subtraction)</a> </li>
<li><a href="manual_Reference.html#IDX343">- (unary minus)</a> </li>
<li><a href="manual_Installing.html#IDX88">.my.cnf file</a>, <a
href="manual_Installing.html#IDX100">.my.cnf file</a>, <a
href="manual_Installing.html#IDX102">.my.cnf file</a>, <a
href="manual_Privilege_system.html#IDX120">.my.cnf file</a>, <a
href="manual_Privilege_system.html#IDX128">.my.cnf file</a>, <a
href="manual_Privilege_system.html#IDX151">.my.cnf file</a>, <a
href="manual_Common_problems.html#IDX715">.my.cnf file</a> </li>
<li><a href="manual_Tools.html#IDX654">.mysql_history file</a> </li>
<li><a href="manual_Maintenance.html#IDX672">.pid (process ID) file</a> </li>
<li><a href="manual_Reference.html#IDX272">/ (division)</a> </li>
<li><a href="manual_Privilege_system.html#IDX152">/etc/passwd</a>, <a
href="manual_Reference.html#IDX525">/etc/passwd</a> </li>
<li><a href="manual_Reference.html#IDX307">< (less than)</a> </li>
<li><a href="manual_Reference.html#IDX282"><< (left shift)</a> </li>
<li><a href="manual_Reference.html#IDX305"><= (less than or equal)</a> </li>
<li><a href="manual_Reference.html#IDX313"><=> (Equal to)</a> </li>
<li><a href="manual_Reference.html#IDX301"><> (not equal)</a> </li>
<li><a href="manual_Reference.html#IDX299">= (equal)</a> </li>
<li><a href="manual_Reference.html#IDX311">> (greater than)</a> </li>
<li><a href="manual_Reference.html#IDX309">>= (greater than or equal)</a> </li>
<li><a href="manual_Reference.html#IDX283">>> (right shift)</a> </li>
<li><a href="manual_Reference.html#IDX168">\" (double quote)</a> </li>
<li><a href="manual_Reference.html#IDX166">\' (single quote)</a> </li>
<li><a href="manual_Reference.html#IDX155">\0 (ASCII 0)</a> </li>
<li><a href="manual_Reference.html#IDX170">\\ (escape)</a> </li>
<li><a href="manual_Reference.html#IDX164">\b (backspace)</a> </li>
<li><a href="manual_Reference.html#IDX157">\n (newline)</a> </li>
<li><a href="manual_Reference.html#IDX161">\r (carriage return)</a> </li>
<li><a href="manual_Reference.html#IDX159">\t (tab)</a> </li>
<li><a href="manual_Reference.html#IDX174">_ (wildcard character)</a> </li>
<li><a href="manual_Reference.html#IDX184">`</a> </li>
</dir>
<h2>A</h2>
<dir>
<li><a href="manual_Reference.html#IDX346">ABS()</a> </li>
<li><a href="manual_Reference.html#IDX365">ACOS()</a> </li>
<li><a href="manual_Reference.html#IDX440">ADDDATE()</a> </li>
<li><a href="manual_Reference.html#IDX267">addition (+)</a> </li>
<li><a href="manual_Problems.html#IDX704">alias</a> </li>
<li><a href="manual_Reference.html#IDX513">ALTER TABLE</a> </li>
<li><a href="manual_Reference.html#IDX281">AND, bitwise</a> </li>
<li><a href="manual_Reference.html#IDX292">AND, logical</a> </li>
<li><a href="manual_Reference.html#IDX274">Arithmetic functions</a> </li>
<li><a href="manual_Reference.html#IDX378">ASCII()</a> </li>
<li><a href="manual_Reference.html#IDX366">ASIN()</a> </li>
<li><a href="manual_Reference.html#IDX367">ATAN()</a> </li>
<li><a href="manual_Reference.html#IDX368">ATAN2()</a> </li>
<li><a href="manual_Clients.html#IDX815">AUTO_INCREMENT, using with DBI</a> </li>
<li><a href="manual_Reference.html#IDX483">AVG()</a> </li>
</dir>
<h2>B</h2>
<dir>
<li><a href="manual_Reference.html#IDX165">backspace (\b)</a> </li>
<li><a href="manual_Reference.html#IDX477">BENCHMARK()</a> </li>
<li><a href="manual_Reference.html#IDX316">BETWEEN ... AND</a> </li>
<li><a href="manual_Reference.html#IDX202">BIGINT</a> </li>
<li><a href="manual_Reference.html#IDX381">BIN()</a> </li>
<li><a href="manual_Reference.html#IDX335">BINARY</a> </li>
<li><a href="manual_Reference.html#IDX275">Bit functions</a> </li>
<li><a href="manual_Reference.html#IDX492">BIT_AND()</a> </li>
<li><a href="manual_Reference.html#IDX285">BIT_COUNT()</a> </li>
<li><a href="manual_Reference.html#IDX491">BIT_OR()</a> </li>
<li><a href="manual_Reference.html#IDX230">BLOB</a>, <a href="manual_Reference.html#IDX249">BLOB</a>
</li>
</dir>
<h2>C</h2>
<dir>
<li><a href="manual_Reference.html#IDX163">carriage return (\r)</a> </li>
<li><a href="manual_Reference.html#IDX340">CASE</a> </li>
<li><a href="manual_Reference.html#IDX334">Casts</a> </li>
<li><a href="manual_Installing.html#IDX45">CC environment variable</a>, <a
href="manual_Installing.html#IDX68">CC environment variable</a> </li>
<li><a href="manual_Reference.html#IDX352">CEILING()</a> </li>
<li><a href="manual_Installing.html#IDX72">CFLAGS environment variable</a> </li>
<li><a href="manual_Reference.html#IDX223">CHAR</a>, <a href="manual_Reference.html#IDX247">CHAR</a>
</li>
<li><a href="manual_Reference.html#IDX226">CHAR VARYING</a> </li>
<li><a href="manual_Reference.html#IDX384">CHAR()</a> </li>
<li><a href="manual_Reference.html#IDX388">CHAR_LENGTH()</a> </li>
<li><a href="manual_Reference.html#IDX224">CHARACTER</a> </li>
<li><a href="manual_Reference.html#IDX225">CHARACTER VARYING</a> </li>
<li><a href="manual_Reference.html#IDX389">CHARACTER_LENGTH()</a> </li>
<li><a href="manual_Clients.html#IDX808">ChopBlanks DBI method</a> </li>
<li><a href="manual_Reference.html#IDX320">COALESCE()</a> </li>
<li><a href="manual_Reference.html#IDX593">Comment syntax</a> </li>
<li><a href="manual_Reference.html#IDX296">Comparison operators</a> </li>
<li><a href="manual_Reference.html#IDX385">CONCAT()</a> </li>
<li><a href="manual_Clients.html#IDX776">connect() DBI method</a> </li>
<li><a href="manual_Reference.html#IDX336">Control flow functions</a> </li>
<li><a href="manual_Reference.html#IDX380">CONV()</a> </li>
<li><a href="manual_Reference.html#IDX362">COS()</a> </li>
<li><a href="manual_Reference.html#IDX369">COT()</a> </li>
<li><a href="manual_Reference.html#IDX480">COUNT()</a> </li>
<li><a href="manual_Reference.html#IDX481">COUNT(DISTINCT)</a> </li>
<li><a href="manual_Reference.html#IDX499">CREATE DATABASE</a> </li>
<li><a href="manual_Reference.html#IDX594">CREATE FUNCTION</a> </li>
<li><a href="manual_Reference.html#IDX591">CREATE INDEX</a> </li>
<li><a href="manual_Reference.html#IDX503">CREATE TABLE</a> </li>
<li><a href="manual_Reference.html#IDX529">CROSS JOIN</a> </li>
<li><a href="manual_Reference.html#IDX447">CURDATE()</a> </li>
<li><a href="manual_Reference.html#IDX448">CURRENT_DATE</a> </li>
<li><a href="manual_Reference.html#IDX450">CURRENT_TIME</a> </li>
<li><a href="manual_Reference.html#IDX453">CURRENT_TIMESTAMP</a> </li>
<li><a href="manual_Reference.html#IDX449">CURTIME()</a> </li>
<li><a href="manual_Installing.html#IDX47">CXX environment variable</a>, <a
href="manual_Installing.html#IDX60">CXX environment variable</a>, <a
href="manual_Installing.html#IDX62">CXX environment variable</a>, <a
href="manual_Installing.html#IDX70">CXX environment variable</a> </li>
<li><a href="manual_Installing.html#IDX49">CXXFLAGS environment variable</a>, <a
href="manual_Installing.html#IDX74">CXXFLAGS environment variable</a> </li>
</dir>
<h2>D</h2>
<dir>
<li><a href="manual_Clients.html#IDX806">data_sources() DBI method</a> </li>
<li><a href="manual_Reference.html#IDX461">DATABASE()</a> </li>
<li><a href="manual_Reference.html#IDX216">DATE</a>, <a href="manual_Reference.html#IDX243">DATE</a>
</li>
<li><a href="manual_Reference.html#IDX421">Date and time functions</a> </li>
<li><a href="manual_Reference.html#IDX438">DATE_ADD()</a> </li>
<li><a href="manual_Reference.html#IDX445">DATE_FORMAT()</a> </li>
<li><a href="manual_Reference.html#IDX439">DATE_SUB()</a> </li>
<li><a href="manual_Reference.html#IDX217">DATETIME</a>, <a
href="manual_Reference.html#IDX242">DATETIME</a> </li>
<li><a href="manual_Reference.html#IDX428">DAYNAME()</a> </li>
<li><a href="manual_Reference.html#IDX425">DAYOFMONTH()</a> </li>
<li><a href="manual_Reference.html#IDX423">DAYOFWEEK()</a> </li>
<li><a href="manual_Reference.html#IDX426">DAYOFYEAR()</a> </li>
<li><a href="manual_Clients.html#IDX775">DBI->connect()</a> </li>
<li><a href="manual_Clients.html#IDX805">DBI->data_sources()</a> </li>
<li><a href="manual_Clients.html#IDX777">DBI->disconnect</a> </li>
<li><a href="manual_Clients.html#IDX783">DBI->do()</a> </li>
<li><a href="manual_Clients.html#IDX781">DBI->execute</a> </li>
<li><a href="manual_Clients.html#IDX795">DBI->fetchall_arrayref</a> </li>
<li><a href="manual_Clients.html#IDX789">DBI->fetchrow_array</a> </li>
<li><a href="manual_Clients.html#IDX791">DBI->fetchrow_arrayref</a> </li>
<li><a href="manual_Clients.html#IDX793">DBI->fetchrow_hashref</a> </li>
<li><a href="manual_Clients.html#IDX797">DBI->finish</a> </li>
<li><a href="manual_Clients.html#IDX779">DBI->prepare()</a> </li>
<li><a href="manual_Reference.html#IDX180">DBI->quote</a> </li>
<li><a href="manual_Clients.html#IDX785">DBI->quote()</a> </li>
<li><a href="manual_Clients.html#IDX799">DBI->rows</a> </li>
<li><a href="manual_Clients.html#IDX809">DBI->trace</a>, <a
href="manual_Porting.html#IDX839">DBI->trace</a> </li>
<li><a href="manual_Clients.html#IDX807">DBI->{ChopBlanks}</a> </li>
<li><a href="manual_Clients.html#IDX813">DBI->{insertid}</a> </li>
<li><a href="manual_Clients.html#IDX816">DBI->{is_blob}</a> </li>
<li><a href="manual_Clients.html#IDX818">DBI->{is_key}</a> </li>
<li><a href="manual_Clients.html#IDX824">DBI->{is_not_null}</a> </li>
<li><a href="manual_Clients.html#IDX820">DBI->{is_num}</a> </li>
<li><a href="manual_Clients.html#IDX822">DBI->{is_pri_key}</a> </li>
<li><a href="manual_Clients.html#IDX826">DBI->{length}</a> </li>
<li><a href="manual_Clients.html#IDX828">DBI->{max_length}</a> </li>
<li><a href="manual_Clients.html#IDX830">DBI->{NAME}</a> </li>
<li><a href="manual_Clients.html#IDX801">DBI->{NULLABLE}</a> </li>
<li><a href="manual_Clients.html#IDX803">DBI->{NUM_OF_FIELDS}</a> </li>
<li><a href="manual_Clients.html#IDX832">DBI->{table}</a> </li>
<li><a href="manual_Clients.html#IDX834">DBI->{type}</a> </li>
<li><a href="manual_Clients.html#IDX811">DBI_TRACE environment variable</a>, <a
href="manual_Porting.html#IDX841">DBI_TRACE environment variable</a> </li>
<li><a href="manual_Reference.html#IDX214">DECIMAL</a> </li>
<li><a href="manual_Reference.html#IDX469">DECODE()</a> </li>
<li><a href="manual_Reference.html#IDX373">DEGREES()</a> </li>
<li><a href="manual_Reference.html#IDX540">DELAYED</a> </li>
<li><a href="manual_Reference.html#IDX519">DELETE</a> </li>
<li><a href="manual_Reference.html#IDX574">DESC</a> </li>
<li><a href="manual_Reference.html#IDX575">DESCRIBE</a> </li>
<li><a href="manual_Clients.html#IDX778">disconnect DBI method</a> </li>
<li><a href="manual_Reference.html#IDX482">DISTINCT</a>, <a
href="manual_Tutorial.html#IDX602">DISTINCT</a> </li>
<li><a href="manual_Reference.html#IDX273">division (/)</a> </li>
<li><a href="manual_Clients.html#IDX784">do() DBI method</a> </li>
<li><a href="manual_Reference.html#IDX210">DOUBLE</a> </li>
<li><a href="manual_Reference.html#IDX212">DOUBLE PRECISION</a> </li>
<li><a href="manual_Reference.html#IDX169">double quote (\")</a> </li>
<li><a href="manual_Reference.html#IDX501">DROP DATABASE</a> </li>
<li><a href="manual_Reference.html#IDX595">DROP FUNCTION</a> </li>
<li><a href="manual_Reference.html#IDX592">DROP INDEX</a> </li>
<li><a href="manual_Reference.html#IDX518">DROP TABLE</a> </li>
<li><a href="manual_Reference.html#IDX526">DUMPFILE</a> </li>
</dir>
<h2>E</h2>
<dir>
<li><a href="manual_Reference.html#IDX411">ELT()</a> </li>
<li><a href="manual_Reference.html#IDX468">ENCODE()</a> </li>
<li><a href="manual_Reference.html#IDX467">ENCRYPT()</a> </li>
<li><a href="manual_Reference.html#IDX236">ENUM</a>, <a href="manual_Reference.html#IDX254">ENUM</a>
</li>
<li><a href="manual_Installing.html#IDX46">Environment variable, CC</a>, <a
href="manual_Installing.html#IDX69">Environment variable, CC</a> </li>
<li><a href="manual_Installing.html#IDX73">Environment variable, CFLAGS</a> </li>
<li><a href="manual_Installing.html#IDX48">Environment variable, CXX</a>, <a
href="manual_Installing.html#IDX61">Environment variable, CXX</a>, <a
href="manual_Installing.html#IDX71">Environment variable, CXX</a> </li>
<li><a href="manual_Installing.html#IDX50">Environment variable, CXXFLAGS</a>, <a
href="manual_Installing.html#IDX75">Environment variable, CXXFLAGS</a> </li>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -