Skip to content

Instantly share code, notes, and snippets.

@mukarramjavid

mukarramjavid/comma_separeted_col_names_in_mysql.sql

Created March 24, 2023 07:16
Show Gist options
  • Save mukarramjavid/ad28158259616dc283c9dc4049c9f92b to your computer and use it in GitHub Desktop.
Save mukarramjavid/ad28158259616dc283c9dc4049c9f92b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
comma_separeted_col_names_in_mysql.sql
SELECT GROUP_CONCAT("m.",COLUMN_NAME)
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = '[database_name]' AND TABLE_NAME = '[table_name]';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment