Funções e funções e…

System Functions
==================
DATABASE( )
IFNULL(exp, value)
USER( )
==================
String functions
==================
ASCII(string_exp)
BIT_LENGTH(string_exp)
CHAR(code)
CHAR_LENGTH(string_exp)
CHARACTER_LENGTH(string_exp)
CONCAT(string_exp1, string_exp2)
DIFFERENCE(string_exp1, string_exp2)
INSERT(string_exp1, start, length, string_exp2)
LCASE(string_exp)
LEFT(string_exp, count)
LENGTH(string_exp)
LOCATE(string_exp1, string_exp2[, start])
LTRIM(string_exp)
OCTET_LENGTH(string_exp)
POSITION(character_exp IN character_exp)
REPEAT(string_exp, count)
REPLACE(string_exp1, string_exp2, string_exp3)
RIGHT(string_exp, count)
RTRIM(string_exp)
SOUNDEX(string_exp)
SPACE(count)
SUBSTRING(string_exp, start, length)
UCASE(string_exp)
==================
Numeric functions
==================
ABS(numeric_exp)
ACOS(float_exp)
ASIN(float_exp)
ATAN(float_exp)
ATAN2(float_exp1, float_exp2)
CEILING(numeric_exp)
COS(float_exp)
COT(float_exp)
DEGREES(numeric_exp)
EXP(float_exp)
FLOOR(numeric_exp)
LOG(float_exp)
LOG10(float_exp)
MOD(integer_exp1, integer_exp2)
PI( )
POWER(numeric_exp, integer_exp)
RADIANS(numeric_exp)
RAND([integer_exp])
ROUND(numeric_exp, integer_exp)
SIGN(numeric_exp)
SIN(float_exp)
SQRT(float_exp)
TAN(float_exp)
TRUNCATE(numeric_exp, integer_exp)
==================
Time and date functions
==================
Function Description
CURRENT_DATE( )
CURRENT_TIME[(time-precision)]
CURRENT_TIMESTAMP[(timestamp-precision)]
CURDATE( )
CURTIME( )
DAYNAME(date_exp)
DAYOFMONTH(date_exp)
DAYOFWEEK(date_exp)
DAYOFYEAR(date_exp)
EXTRACT(extract-field FROM extract-source)
HOUR(time_exp)
MINUTE(time_exp)
MONTH(date_exp)
MONTHNAME(date_exp)
NOW( )
QUARTER(date_exp)
SECOND(time_exp)
TIMESTAMPDIFF(interval, timestamp_exp1, timestamp_exp2)
WEEK(date_exp)
YEAR(date_exp)
==================

3 comentários »

  1. Lázaro Mariano said

    Preciso da função Exp(), como faço para obtê-la.?

  2. June said

    Currently we pull the vacuum out of the hallway closet, turn it on,
    and clean it up everything involving the floor and our
    feet. All these appliances are available inside the on line
    markets at affordable prices.

  3. weebly.com said

    I think the admin of this site is in fact working hard for his web site, because here every material
    is quality based stuff.

RSS feed for comments on this post · TrackBack URI

Deixe uma Resposta

Preencha os seus detalhes abaixo ou clique num ícone para iniciar sessão:

Logótipo da WordPress.com

Está a comentar usando a sua conta WordPress.com Terminar Sessão / Alterar )

Imagem do Twitter

Está a comentar usando a sua conta Twitter Terminar Sessão / Alterar )

Facebook photo

Está a comentar usando a sua conta Facebook Terminar Sessão / Alterar )

Google+ photo

Está a comentar usando a sua conta Google+ Terminar Sessão / Alterar )

Connecting to %s

%d bloggers like this: