Sorting and using MySQL built-in functions

Sorting and using MySQL built-in functions

See mysql Official Website: Introduction to functions and operators

For time and date functions, see Mysql5.5 official documentation.

General examples

1. view the current system date

Call the date function.

Mysql> select now ();

Mysql> select sysdate ();

Mysql> select current_date ();

2. view database information

Mysql> select database () Current database
Mysql> select verdion () current version
Mysql> select user () current user

To be continued