What is the result of concatenating server_id and UUID in MySQL?

Yes, you can easily connect the server ID and UUID. The syntax is as follows:

SELECT CONCAT(@@ server_id,UUID())

In the above code, we use @@server_id to get the value of server_id. @@server_id is a system-defined variable. Now let us take a look at the query statement

mysql> SELECT CONCAT(@@server_id, UUID()) AS ServerUUIDDemo;

The following is the output showing the concatenation result of server_id and UUID

+---------------------------------------+
| ServerUUIDDemo                        |
+---------------------------------------+
| 14d16521c-3161-11e9-9ed7-78843ce8de7e |
+---------------------------------------+
1 row in set (0.00 sec)

The above is the detailed content of What is the result of concatenating server_id and UUID in MySQL?. For more information, please follow other related articles on the PHP Chinese website!