The || pipes operator in a string expression concatenates two or more character or binary strings, columns, or a combination of strings and column names into one expression (a string operator). For ...

/* Another strategy to add a surrogate key to an existing table is to concatenate existing columns with the CONCAT() function. The table is populated with 10 rows of completely fictional data.