How to show mysql tables in one line?

Question

Show tables lists a formatted output.

+----------------------------+
|           Tables           |
+----------------------------+
| table1                     |
| table2                     |
| table3                     |
+----------------------------+

How do I make the output like "table1, table2, table3, ..." ?

see this http://stackoverflow.com/questions/194852/concatenate-many-rows-into-a-single-text-string — Pantamtuy, Oct 14 '14 at 05:09

score 7 · Accepted Answer · edited Oct 14 '14 at 05:08

7

SELECT
    GROUP_CONCAT(table_name)
FROM information_schema.tables

edited Oct 14 '14 at 05:08

M Khalid Junaid

62,293
9
87
115

answered Oct 14 '14 at 05:00

Alex Woolford

4,203
10
43
74

How to show mysql tables in one line?

1 Answers1