MySQL Basic learning function

Mathematical functions

Absolute ABS ()

Pi ()

Square root sqrt ()

Modulo to remove the remainder mod (dividend, divisor)

Random number rand ()

Rounding Round (number)

Second party POW (5,2)

E is the bottom exponent function exp (number)

String functions

Length of character (character)

Character Connection concat (character 1, character 2)

Signed character Connection Concat_ws ('-', ' su ', ' Zhou ')

Inserting characters into insert (' Suzhou ', ' Yang ')

String uppercase upper (character)

String lowercase lower (character)

string comparison strcmp (character 1, character 2)

String intercept substring (character, 3,4)

String position locate (character 1, character 2)

Time

Date Curdate ()

Time-Division seconds Curtime ()

Detail time Now ()

Get lowercase months month (' 2014-5-14 ')

Get the capital month MonthName (' 2014-5-15 ')

Get Week dayname (' 2014-5-16 ')

One day of the Week DayOfWeek (' 2014-5-17 ')

Number of weeks in a year week (' 2014-5-18 ')