MySQL learns five SQL utility functions

0 Select Now ()

　　Displays the current time.

1 Select char_length (' Andyqan ')

　　Displays the character length.

Date of 2nd format

Select Date_format (now (), '%y-%m-%d ')

3 Add/Decrease Date Time

Select Date_add (now (), Interval 1 day)

4 Type conversions

Select cast (187000000 as Char)

5 Cryptographic functions

　　MD5 is irreversible, that is, unbreakable. However, the same data must be MD5 encrypted, so it can be used for password checking. The network on the crack MD5 is not true crack.

After forgetting the QQ password, you can reset it.

Select MD5 ("Andyqian");

6 string concatenation

Select Concat (' A ', ' B ', ' C ')

7 JSON functions (5.7 support later)

Select Json_object ("name", "Andyqian", "Database", "MySQL");

· Select Json_array ("name", "Andyqian", "Database", "MySQL");

MySQL learns five SQL utility functions