Mysql> insert into sales(sales_rep, sale)īonus Read : How to Calculate Running Total in MySQL Let’s say you have the following table sales(sales_rep, sale) mysql> create table sales(sales_rep varchar(255),sale int) Here are the steps to concatenate multiple rows into one column in MySQL. How to Concatenate Multiple Rows into One Column in MySQL You can also use it to concatenate rows into string, or get multiple row data in single row in MySQL.
Here’s how to concatenate multiple rows into one column in MySQL using GROUP_CONCAT function. Sometimes you might need to combine multiple rows into one column.
