SQL Line Breaks: Using CONCAT Function

In SQL, you can use the CONCAT function to output data with line breaks. For example, you can combine two fields into one field and add a line break between them using the following statement.

SELECT CONCAT(field1, '\n', field2) AS combined_field
FROM table_name;

In this example, field1 and field2 are two fields to be combined, ‘\n’ represents a line break, and combined_field is the name of the combined field. When running this query, the output will display the data between field1 and field2 with line breaks.