mysqlÂ≠òÂÇ®òqáÁ®ãÂü∫Êú¨ÂáΩÊï∞

CHARSET(str) //òqîÂõûÂ≠ó‰∏≤Â≠óÁ¨¶Èõ?br /> CONCAT (string2  [,... ]) //òqûÊé•Â≠ó‰∏≤
INSTR (string ,substring ) //òqîÂõûsubstringȶñʨ°Âú®string‰∏≠Âá∫Áé∞ÁöщΩçÁΩÆ,‰∏çÂ≠òÂú®ËøîÂõ?
LCASE (string2 ) //ËΩ¨Êç¢ÊàêÂ∞èÂÜ?br /> LEFT (string2 ,length ) //‰ªéstring2‰∏≠ÁöÑÂ∑¶Ëæπ˵∑Âèñlength‰∏™Â≠óΩW?br /> LENGTH (string ) //stringÈïøÂ∫¶
LOAD_FILE (file_name ) //‰ªéÊñቪ∂ËتÂèñÂÜÖÂÆ?br /> LOCATE (substring , string  [,start_position ] ) ÂêåINSTR,‰ΩÜÂèØÊåáÂÆöºÄÂßã‰Ωçæ|?br /> LPAD (string2 ,length ,pad ) //Èáç§çÁî®padÂä†Âú®stringºÄ§?Áõ¥Âà∞Â≠ó‰∏≤ÈïøÂ∫¶‰∏∫length
LTRIM (string2 ) //ÂéªÈô§ÂâçÁ´ØΩI∫ʆº
REPEAT (string2 ,count ) //Èáç§çcountã∆?br /> REPLACE (str ,search_str ,replace_str ) //Âú®str‰∏≠Áî®replace_strÊõøÊç¢search_str
RPAD (string2 ,length ,pad) //在str后用pad补充,直到长度为length
RTRIM (string2 ) //ÂéªÈô§ÂêéÁ´ØΩI∫ʆº
STRCMP (string1 ,string2 ) //ÈÄêÂ≠óΩW¶ÊØîËæɉ∏§Â≠ó‰∏≤§ßÂ∞è,
SUBSTRING (str , position  [,length ]) //‰ªéstrÁöÑpositionºÄÂß?Âèñlength‰∏™Â≠óΩW?
Ê≥®Ôºömysql‰∏≠§ÑÁêÜÂ≠óΩW¶‰∏≤Êó”ûºåȪòËƧΩW¨‰∏ĉ∏™Â≠óΩW¶‰∏ãʆá‰ÿì1ÂQåÂç≥ÂèÇÊï∞positionÂøÖÈ°ªÂ§ß‰∫éΩ{â‰∫é1

 

TRIM([[BOTH|LEADING|TRAILING] [padding] FROM]string2) //ÂéªÈô§ÊåáÂÆö‰ΩçÁΩÆÁöÑÊåáÂÆöÂ≠óΩW?br /> UCASE (string2 ) //ËΩ¨Êç¢Êàê§ßÂÜ?br /> RIGHT(string2,length) //Âèñstring2ÊúÄÂêélength‰∏™Â≠óΩW?br /> SPACE(count) //ÁîüÊàêcount‰∏™Á©∫ʆ?nbsp;

ABS (number2 ) //ælùÂØπÂÄ?br /> BIN (decimal_number ) //ÂçÅËøõÂà∂Ëù{‰∫åËøõÂà?br /> CEILING (number2 ) //Âêë‰∏äÂèñÊï¥
CONV(number2,from_base,to_base) //òqõÂà∂ËΩ¨Êç¢
FLOOR (number2 ) //向下取整
FORMAT (number,decimal_places ) //‰øùÁïôûÆèÊï∞‰ΩçÊï∞
HEX (DecimalNumber ) //ËΩ¨ÂçÅÂÖ≠ËøõÂà?br /> Ê≥®ÔºöHEX()‰∏≠Âè؉º†ÂÖ•Â≠óÁ¨¶‰∏‘åºåÂàôËøîÂõûÂÖ∂ASC-11Á†ÅÔºå¶ÇHEX(’DEF’)òqîÂõû4142143
‰πüÂè؉ª•‰º†ÂÖ•ÂçÅòqõÂà∂Êï¥Êï∞ÂQåËøîÂõûÂÖ∂ÂçÅÂÖ≠òqõÂà∂æ~ñÁ†ÅÂQå¶ÇHEX(25)òqîÂõû19
LEAST (number , number2  [,..]) //ʱÇÊúÄûÆèÂÄ?br /> MOD (numerator ,denominator ) //ʱljΩô
POWER (number ,power ) //ʱÇÊåáÊï?br /> RAND([seed]) //ÈöèÊú∫Êï?br /> ROUND (number  [,decimals ]) //ÂõõËàç‰∫îÂÖ•,decimals‰∏∫Â∞èÊïÓCΩçÊï∞]

 

SIGN (number2 ) //òqîÂõûΩW¶Âè∑,Ê≠£Ë¥üÊà?
SQRT(number2) //ºÄÚqœxñπ

ADDTIME (date2 ,time_interval ) //ûÆÜtime_intervalÂä†Âà∞date2
CONVERT_TZ (datetime2 ,fromTZ ,toTZ ) //转换时区
CURRENT_DATE (  ) //ÂΩìÂâçÊó•Êúü
CURRENT_TIME (  ) //ÂΩìÂâçÊóâôó¥
CURRENT_TIMESTAMP (  ) //ÂΩìÂâçÊóâôó¥Êà?br /> DATE (datetime ) //òqîÂõûdatetimeÁöÑÊó•ÊúüÈÉ®Âà?br /> DATE_ADD (date2 , INTERVAL d_value d_type ) //Âú®date2‰∏≠Â䆉∏äÊó•ÊúüÊàñÊóâôó¥
DATE_FORMAT (datetime ,FormatCodes ) //‰ΩøÁî®formatcodesʆºÂºèÊòÑ°§∫datetime
DATE_SUB (date2 , INTERVAL d_value d_type ) //Âú®date2‰∏äÂáèÂé÷M∏ĉ∏™Êó∂Èó?br /> DATEDIFF (date1 ,date2 ) //‰∏§‰∏™Êó•ÊúüÂ∑?br /> DAY (date ) //òqîÂõûÊó•ÊúüÁöѧ©
DAYNAME (date ) //英文星期
DAYOFWEEK (date ) //星期(1-7) ,1为星期天
DAYOFYEAR (date ) //‰∏ÄÚq¥‰∏≠ÁöÑÁ¨¨Âá†Â§©
EXTRACT (interval_name  FROM date ) //‰ªédate‰∏≠ÊèêÂèñÊó•ÊúüÁöÑÊåáÂÆöÈÉ®ÂàÜ
MAKEDATE (year ,day ) //ælôÂá∫Úq¥ÂèäÚq¥‰∏≠ÁöÑÁ¨¨Âá†Â§©,ÁîüÊàêÊó•Êúü‰∏?br /> MAKETIME (hour ,minute ,second ) //ÁîüÊàêÊóâôó¥‰∏?br /> MONTHNAME (date ) //Ëã±ÊñáÊúà‰ÜæÂê?br /> NOW (  ) //ÂΩìÂâçÊóâôó¥
SEC_TO_TIME (seconds ) //øUíÊï∞ËΩ¨ÊàêÊóâôó¥
STR_TO_DATE (string ,format ) //Â≠ó‰∏≤ËΩ¨ÊàêÊóâôó¥,‰ª•formatʆºÂºèÊòÑ°§∫
TIMEDIFF (datetime1 ,datetime2 ) //‰∏§‰∏™Êóâôó¥Â∑?br /> TIME_TO_SEC (time ) //Êóâôó¥ËΩ¨ÁßíÊï∞]
WEEK (date_time [,start_of_week ]) //ΩW¨Âá†Âë?br /> YEAR (datetime ) //Úq¥‰Üæ
DAYOFMONTH(datetime) //ÊúàÁöÑΩW¨Âá†Â§?br /> HOUR(datetime) //ûÆèÊó∂
LAST_DAY(date) //dateÁöÑÊúàÁöÑÊúÄÂêéÊó•Êú?br /> MICROSECOND(datetime) //ÂæÆÁßí
MONTH(datetime) //Êú?br /> MINUTE(datetime) //Âà?/div>

ãπ™ÊòOãπÔLõó 2008-10-15 14:55 ÂèëË°®ËØÑËÆ∫