MySql store strings in variables and concatenate them to return them to the terminal

Viewed 5684

Let's say that I have:

SET @fname := "James", @mname := "Robert", @lname := "Maxon";

How would I set a variable that would contain the concatenated result of the above variables?

2 Answers
Related