How to obtain all field names of a table separated by commas _ MySQL

Since Oracle9i, you can use the SYS_CONNECT_BY_PATH function to display the content from the parent node to the current row in the form of "path" or a list of hierarchical elements. Obtain the names of all fields in a table and separate them with commas. Selectmax (substr (SYS_CONNECT_BY_PATH (COLUMN_NAME,), 2) colfrom (selectCOLUMN_NAME, colu since Oracle 9i, you can use the SYS_CONNECT_BY_PATH function to implement
The row content is displayed in the form of "path" or a list of hierarchical elements.

Obtain the names of all fields in a table and separate them with commas.

Select max (substr (SYS_CONNECT_BY_PATH (COLUMN_NAME, ','), 2) col from (
Select COLUMN_NAME, column_id from user_tab_columns where table_name = '& table name ')
Start with column_id = 1
Connect by column_id = rownum;