Sintaxis Bien
[NATIONAL] CHAR(M) [BINARY]
[NATIONAL] VARCHAR(M) [BINARY]
BIGINT[(M)] [UNSIGNED] [ZEROFILL]
BIT
BLOB
BOOL
CHAR
DATE
DATETIME
DECIMAL[(M[,D])] [ZEROFILL]
DOUBLEPRECISION[(M,D)]
[ZEROFILL]
DOUBLE[(M,D)] [ZEROFILL]
ENUM('value1','value2',...)
FLOAT(precision) [ZEROFILL]
FLOAT[(M,D)] [ZEROFILL]
INT[(M)] [UNSIGNED] [ZEROFILL]
INTEGER[(M)] [UNSIGNED]
[ZEROFILL]STRING COMPARISON FUNCTIONS
+
!=
=
>
expr NOT IN
IS NOT NULL
(value,...)
IS NULL
INTERVAL(N,N1,N2,N3,.. ISNULL(expr)
.)
LOGICAL OPERATORS
AND (&&)
NOT (!)
OR (||)CONTROL FLOW FUNCTIONS
CASE value WHEN [compare-value] THEN result [WHEN [compare-value]
THEN result ...] [ELSE result] END
CASE WHEN [condition] THEN result [WHEN [condition] THEN result ...][ELSE result] END
IF(expr1,expr2,expr3)
IFNULL(expr1,expr2)
NULLIF(expr1,expr2)
LPAD(str,len,padstr)
LTRIM(str)
MAKE_SET(bits,str1,str2,...)
MID(str,pos,len)
OCT(N)
OCTET_LENGTH(str)
ORD(str)POSITION(substr IN str)
REPEAT(str,count)
REPLACE(str,from_str,to_str)
REVERSE(str)
RIGHT(str,len)
RPAD(str,len,padstr)
RTRIM(str)
SOUNDEX(str)
SPACE(N)
SUBSTRING(str FROM pos FOR len)SUBSTRING(str FROM pos)
SUBSTRING(str,pos)
SUBSTRING(str,pos,len)
SUBSTRING_INDEX(str,delim,count)
TRIM([[BOTH | LEADING | TRAILING]
[remstr] FROM] str)
UCASE(str)
UPPER(str)
MATHEMETICALFUNCTIONS
ABS(X)
ACOS(X)
ASIN(X)
ATAN(X)
ATAN(Y,X)
ATAN2(Y,X)
CEILING(X)
COS(X)
COT(X)
DEGREES(X)
EXP(X)
FLOOR(X)
GREATEST(X,Y,...)
LEAST(X,Y,...)
LOG(X)
ADDDATE(date,INTERVAL exprtype)
CURDATE()
CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
CURTIME()
DATE_ADD(date,INTERVAL expr type)
DATE_FORMAT(date,format)
DATE_SUB(date,INTERVAL expr type)
DAYNAME(date)
DAYOFMONTH(date)DAYOFWEEK(date)
DAYOFYEAR(date)
EXTRACT(type FROM date)
FROM_DAYS(N)
FROM_UNIXTIME(unix_timestamp)
FROM_UNIXTIME(unix_timestamp,form
at)
HOUR(time)
MINUTE(time)
MONTH(date)
LOG10(X)...
Regístrate para leer el documento completo.