474 0 0 0
Last Updated : 2024-03-28 22:26:06
If you want to get a table column names from mysql database as a concatenated string, you can use the following code
SELECT group_concat(COLUMN_NAME)
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'chamberstream' AND TABLE_NAME = 'phases';
//------------------------------------------------------
SHOW COLUMNS FROM phases