mysql常用函数实例

mysql常用函数实例

mysql> select 18 / 5 , 18 % 5;
+--------+--------+
| 18 / 5 | 18 % 5 |
+--------+--------+
| 3.6000 |      3 |
+--------+--------+
1 row in set (0.00 sec)

mysql> select degrees(pi()/4);
+-----------------+
| degrees(pi()/4) |
+-----------------+
|              45 |
+-----------------+
1 row in set (0.00 sec)

mysql> select power(9, 4);
+-------------+
| power(9, 4) |
+-------------+
|        6561 |
+-------------+
1 row in set (0.00 sec)

mysql> select round(3.14159, 2);
+-------------------+
| round(3.14159, 2) |
+-------------------+
|              3.14 |
+-------------------+
1 row in set (0.00 sec)

mysql> select length('hello world!'), length('university');
+------------------------+----------------------+
| length('hello world!') | length('university') |
+------------------------+----------------------+
|                     12 |                   10 |
+------------------------+----------------------+
1 row in set (0.00 sec)

mysql> select mid('nice to meet you!',9, 4);
+-------------------------------+
| mid('nice to meet you!',9, 4) |
+-------------------------------+
| meet                          |
+-------------------------------+
1 row in set (0.00 sec)



mysql> select repeat('cheer', 3);
+--------------------+
| repeat('cheer', 3) |
+--------------------+
| cheercheercheer    |
+--------------------+
1 row in set (0.00 sec)


mysql> select reverse('voodoo');
+-------------------+
| reverse('voodoo') |
+-------------------+
| oodoov            |
+-------------------+
1 row in set (0.00 sec)


mysql> select make_set(1 | 3 | 4, 'Mysql', 'not', 'is', 'great');
+----------------------------------------------------+
| make_set(1 | 3 | 4, 'Mysql', 'not', 'is', 'great') |
+----------------------------------------------------+
| Mysql,not,is                                       |
+----------------------------------------------------+
1 row in set (0.00 sec)

mysql> select weekofyear(curdate());
+-----------------------+
| weekofyear(curdate()) |
+-----------------------+
|                    15 |
+-----------------------+
1 row in set (0.00 sec)

mysql> select dayofweek(curdate());
+----------------------+
| dayofweek(curdate()) |
+----------------------+
|                    2 |
+----------------------+
1 row in set (0.00 sec)

mysql> select year(curdate()) - year('1929-2-14');
+-------------------------------------+
| year(curdate()) - year('1929-2-14') |
+-------------------------------------+
|                                  93 |
+-------------------------------------+
1 row in set (0.00 sec)

mysql> select date_format(curdate(), '%Y %M %D %W');
+---------------------------------------+
| date_format(curdate(), '%Y %M %D %W') |
+---------------------------------------+
| 2022 April 11th Monday                |
+---------------------------------------+
1 row in set (0.00 sec)


mysql> select unix_timestamp();
+------------------+
| unix_timestamp() |
+------------------+
|       1649652323 |
+------------------+
1 row in set (0.00 sec)

mysql> show processlist;
+----+-----------------+-----------+---------+---------+---------+------------------------+------------------+
| Id | User            | Host      | db      | Command | Time    | State                  | Info             |
+----+-----------------+-----------+---------+---------+---------+------------------------+------------------+
|  5 | event_scheduler | localhost | NULL    | Daemon  | 1113912 | Waiting on empty queue | NULL             |
| 11 | root            | localhost | test_db | Query   |       0 | init                   | show processlist |
+----+-----------------+-----------+---------+---------+---------+------------------------+------------------+
2 rows in set (0.00 sec)