Shulou(Shulou.com)06/01 Report--

This article will explain in detail what the built-in functions in mysql are, and the editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

Mysql function

MySQL has many built-in functions, and the descriptions of these functions are listed below.

Aggregate function

Avg

Count

Max

Min

Sum

Functions used to process strings

Merge string function: concat (str1,str2,str3...)

Compare string size function: strcmp (str1,str2)

Get string byte function: length (str)

Function to get the number of characters in a string: char_length (str)

Letter case conversion function: uppercase: upper (x), ucase (x); lowercase lower (x), lcase (x)

Functions used to handle numeric values

Absolute value function: abs (x)

Take the whole function up: ceil (x)

Take the whole function down: floor (x)

Modulo function: mod (XBI y)

Random number function: rand ()

Rounding function: round (xrem y)

Numerical intercept function: truncate (xpeny)

Functions for dealing with time and date

Get current date: curdate (), current_date ()

Get the current time: curtime (), current_time ()

Get the current date and time: now ()

Select months from the date: month (date), monthname (date)

Select number of weeks from date: week (date)

Select number of weeks from date: year (date)

Select hours from time: hour (time)

Select minutes from time: minute (time)

Choose what day it is today from the time: weekday (date), dayname (date)

On the mysql built-in functions which are shared here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.