How to concatenate table columns in SQL

In this post, we are going to teach you how to concatenate tabe coums in SQL.

Example: 

select GROUP_CONCAT(COLUMN_NAME) from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='users';

Result: