mysql - What does double bars (||) mean in SQL?

Question

(This question already has answers here): question from:https://stackoverflow.com/questions/23919378/what-does-double-bars-mean-in-sql

Answer 1

double bars are concatination:

select 'hello' || ' ' || 'world' from dual;

yields

'hello world'