MySQL basic learning functions

MySQL basic learning functions Mathematical functions

Absolute value abs ()

PI ()

Square root sqrt ()

Mod (divisor, divisor)

Random number rand ()

Round (number)

Power pow (5, 2)

Base e: exponential function exp (number)

String functions

Length (character)

Concat (Character 1, Character 2)

Concat_ws ('-', 'Su ', 'zhou ')

Insert ('suzhou', 1, 2, 'Yang ')

String uppercase upper (character)

String lower-case lower (character)

String comparison strcmp (Character 1, Character 2)

String truncation substring (character, 3, 4)

String location locate (Character 1, Character 2)

Time

Year Month Day curdate ()

Hour, minute, second, curtime ()

Detailed time now ()

Obtain the month ('1970-5-14 ') in lower case ')

Obtain the monthname ('2017-5-15 ') of the upper-case month ')

Get the day name of the week ('2017-5-16 ')

One day of the week dayofweek ('2017-5-17 ')

Week ('2017-5-18 ')