How to show mysql tables in one line? [duplicate]

Question

Show tables lists a formatted output.

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

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

do you mean in mysql?

Hendry Tanaka
– Hendry Tanaka

2014-10-14 04:59:50 +00:00
Commented Oct 14, 2014 at 4:59 — Hendry Tanaka
– Hendry Tanaka, Commented Oct 14, 2014 at 4:59
see this stackoverflow.com/questions/194852/…

Pantamtuy
– Pantamtuy

2014-10-14 05:09:07 +00:00
Commented Oct 14, 2014 at 5:09 — Pantamtuy
– Pantamtuy, Commented Oct 14, 2014 at 5:09

M Khalid Junaid · Accepted Answer · 2014-10-14 05:08:04Z

7

SELECT
    GROUP_CONCAT(table_name)
FROM information_schema.tables

edited Oct 14, 2014 at 5:08

M Khalid Junaid

64.6k10 gold badges93 silver badges120 bronze badges

answered Oct 14, 2014 at 5:00

Alex Woolford

4,58311 gold badges51 silver badges82 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to show mysql tables in one line? [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related