Mysql CONCAT () connection string

Mysql tutorial concat () connection string details
In some cases, If you want two or more strings, there is a string connection function concat () in mysql. Let's talk about how to use it.

Concat syntax
Concat (str1, str2 ,...)

Connect two strings in a simple instance

Select concat ('hello', 'World! ');

Of course, you can also use fields in the table instead of string constants. You can use them together. Let's take a look at a slightly complex example. Assume that we have a name and age in the User table, and now we want to connect them together, we can use select statement uses the concat

Select concat (name, 'is ', age, 'ears old.') from user;

Bill is 28 years old.
Mark is 32 years old.
Julia is 44 years old.
Alex is 52 years old.