mysql calculation function details

mysql calculation function details

Functions are not as portable as SQL . Code that can run on multiple systems is called portable . Most SQL statements are relatively portable, and when there are differences between SQL implementations, those differences are usually not that difficult to deal with.

However, the portability of functions is not strong. Almost every major DBMS implementation supports functions that other implementations do not, and the differences are sometimes significant. For the sake of code portability, many SQL programmers do not favor the use of special implementation features. Although this is beneficial,

But it is not always good for application performance. Without using these functions, writing some application code would be difficult. Other methods must be utilized to accomplish the work that the DBMS does very efficiently.

If you decide to use functions, you should make sure to comment your code so that later on you (or others) know exactly what the SQL you wrote means.

2. Field concatenation

SELECT CONCAT(vend_name,'(',vend_country,')') as info
from vendors
ORDER BY vend_name

MySQL also supports the following operators:

2. Give some examples of mysql functions

2.1 Symbol Processing

Left() Returns the characters on the left side of a string Length() Returns the length of a string Locate() Finds a substring of a string Lower() Converts a string to lowercase LTrim() Removes spaces on the left side of a string Right() Returns the characters on the right side of a string RTrim() Removes spaces on the right side of a string Soundex() Returns the SOUNDEX value of a string SubString() Returns the characters of a substring Upper() Converts a string to uppercase

2.2 Phase Treatment

AddDate() adds a date (day, week, etc.)
AddTime() adds a time (hour, minute, etc.)
CurDate() Returns the current dateCurTime() Returns the current timeDate() Returns the date portion of a date and timeDateDiff() Calculates the difference between two datesDate_Add() Highly flexible date operation functionDate_Format() Returns a formatted date or time stringDay() Returns the day portion of a dateDayOfWeek() Returns the corresponding day of the week for a dateHour() Returns the hour portion of a timeMinute() Returns the minute portion of a timeMonth() Returns the month portion of a dateNow() Returns the current date and timeSecond() Returns the seconds portion of a timeTime() Returns the hour portion of a date and timeYear() Returns the year portion of a date

2.3 Value Processing

Abs() Returns the absolute value of a numberCos() Returns the cosine of an angleExp() Returns the exponential value of a numberMod() Returns the remainder of a division operationPi() Returns the ratio of piRand() Returns a random numberSin() Returns the sine of an angleSqrt() Returns the square root of a numberTan() Returns the tangent of an angle

This is the end of this article about the details of mysql calculation functions. For more relevant mysql calculation function content, please search for previous articles on 123WORDPRESS.COM or continue to browse the following related articles. I hope everyone will support 123WORDPRESS.COM in the future!

You may also be interested in:
  • MySQL detailed summary of commonly used functions
  • Comprehensive summary of mysql functions
  • A brief introduction to MySQL functions
  • Introduction to commonly used functions in MYSQL database

<<:  Click the button to turn the text into an input box, click Save to turn it into text implementation code

>>:  Negative margin function introduction and usage summary

Recommend

Detailed analysis of each stage of nginx's http request processing

When writing the HTTP module of nginx, it is nece...

VUE+Canvas implements the game of God of Wealth receiving ingots

Welcome to the previous canvas game series: 《VUE ...

Nginx access log and error log parameter description

illustrate: There are two main types of nginx log...

A brief summary of vue keep-alive

1. Function Mainly used to preserve component sta...

Docker enables seamless calling of shell commands between container and host

As shown below: nsenter -t 1 -m -u -n -i sh -c &q...

HTML table tag tutorial (45): table body tag

The <tbody> tag is used to define the style...

How to use jsonp in vue

Table of contents 1. Introduction 2. Installation...

MySql8 WITH RECURSIVE recursive query parent-child collection method

background When developing a feature similar to c...

Implementation of mysql data type conversion

1. Problem There is a table as shown below, we ne...

How to change mysql password under Centos

1. Modify MySQL login settings: # vim /etc/my.cnf...

4 ways to modify MySQL root password (summary)

Method 1: Use the SET PASSWORD command First log ...

JavaScript implements password box input verification

Sometimes it is necessary to perform simple verif...

Installation, configuration and use of process daemon supervisor in Linux

Supervisor is a very good daemon management tool....

How to query duplicate data in mysql table

INSERT INTO hk_test(username, passwd) VALUES (...