A concise tutorial of SQL statements for Linux---concatenate

Sometimes, we need to concatenate the data obtained from different fields. Each database provides a way to achieve this: Mysql:concat () Oracle:concat (), | | SQL Server: + The syntax for CONCAT () is as follows: CONCAT (String 1, String 2, String 3, ...) Concatenate string 1, String 2, String 3, and so on. Please note that Oracle's CONCAT () only allows two parameters, in other words, only two strings can be concatenated at a time. However, in Oracle, we can concatenate multiple strings at once with ' | | '. Take a look at some examples. Suppose we have the following table: Geography Form Region_name Store_name East Boston East New York West Los Angeles West San Diego Example 1 mysql/oracle: SELECT CONCAT (Region_name, store_name) from Geography WHERE store_name = ' Boston '; Results: ' Eastboston ' Example 2 Oracle: SELECT Region_name | | "| | Store_name from Geography WHERE store_name = ' Boston '; Results: ' East Boston ' Example 3 SQL Server: SELECT region_name + "+ store_name from Geography WHERE store_name = ' Boston '; Results: ' East Boston ' 

Linux is measured as follows:

Reprint please specify: Xiao Liu

A concise tutorial of SQL statements for Linux---concatenate