Course
Trainer
More
Premium
Log in
String functions
18
LENGTH
SUBSTRING
REPLACE
LOCATE
LOWER
UPPER
REVERSE
TRIM
LPAD
RPAD
LTRIM
RTRIM
REPEAT
CONCAT
INSTR
LEFT
RIGHT
CHAR
Numeric functions
14
CEILING
FLOOR
ROUND
ABS
MOD
GREATEST
LEAST
RAND
POW
SQRT
SIGN
EXP
LOG
PI
Date and time functions
19
NOW
TIMESTAMPADD
TIMESTAMPDIFF
DATE_FORMAT
DATE
DATEDIFF
TIMEDIFF
ADDDATE
SUBDATE
YEAR
MONTH
DAY
HOUR
MINUTE
CURDATE
CURTIME
MONTHNAME
DAYNAME
DAYOFWEEK
Advanced functions
6
WITH
ISNULL
IF
COALESCE
IFNULL
NULLIF
REPEAT
Returns a string obtained from count repetitions of the string str
MySQL
REPEAT
(
str
,
count
)
Examples
MySQL
SELECT
REPEAT
(
'111'
,
3
)
;
String functions
18
LENGTH
SUBSTRING
REPLACE
LOCATE
LOWER
UPPER
REVERSE
TRIM
LPAD
RPAD
LTRIM
RTRIM
REPEAT
CONCAT
INSTR
LEFT
RIGHT
CHAR
Numeric functions
14
CEILING
FLOOR
ROUND
ABS
MOD
GREATEST
LEAST
RAND
POW
SQRT
SIGN
EXP
LOG
PI
Date and time functions
19
NOW
TIMESTAMPADD
TIMESTAMPDIFF
DATE_FORMAT
DATE
DATEDIFF
TIMEDIFF
ADDDATE
SUBDATE
YEAR
MONTH
DAY
HOUR
MINUTE
CURDATE
CURTIME
MONTHNAME
DAYNAME
DAYOFWEEK
Advanced functions
6
WITH
ISNULL
IF
COALESCE
IFNULL
NULLIF