mysql_concat_ws.md

MySQL concat_ws

效果等同于编程语言 字符串数组的 join

select concat_ws('.', '127', '0', '0', '1');

MariaDB [test]> select concat_ws('.', '127', '0', '0', '1');
+--------------------------------------+
| concat_ws('.', '127', '0', '0', '1') |
+--------------------------------------+
| 127.0.0.1                            |
+--------------------------------------+
1 row in set (0.000 sec)

MariaDB [test]> select sleep(5) from dual;
+----------+
| sleep(5) |
+----------+
|        0 |
+----------+
1 row in set (5.000 sec)

MariaDB [test]> select md5(concat_ws('.', '127', '0', '0', '1'));
+-------------------------------------------+
| md5(concat_ws('.', '127', '0', '0', '1')) |
+-------------------------------------------+
| f528764d624db129b32c21fbca0cb8d6          |
+-------------------------------------------+