How Can I see an empty table structure in mysql?

Question

I'm using terminal for mysql

I want to know what column my table has, but it's empty and dont show anything to me

Show Databases;

+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
| test               |
+--------------------+

Use test

Database changed

Show Tables;

+----------------+
| Tables_in_test |
+----------------+
| tblPerson      |
| tblStudent     |
+----------------+

What Should I do to see the column of my table, even if its empty, like this:

+----+-----------------+---------+
| id | name            | is_male |
+----+-----------------+---------+
|    |                 |         |
+----+-----------------+---------+

not this:

Empty set (0.00 sec)

Possible duplicate of [How can I get column names from a table in SQL Server?](https://stackoverflow.com/questions/1054984/how-can-i-get-column-names-from-a-table-in-sql-server) — Standin.Wolf, Nov 05 '19 at 13:45

score 8 · Accepted Answer · answered Nov 05 '19 at 13:43

8

Type this command you will get the column names of your table.

desc tblPerson;

answered Nov 05 '19 at 13:43

Kaleemullah

446
3
8

score 2 · Answer 2 · answered Nov 05 '19 at 13:43

2

Show table structure: describe [table]; or desc [table];

answered Nov 05 '19 at 13:43

Manish Sharma

210
3
12

score 2 · Answer 3 · answered Nov 05 '19 at 13:53

2

You can use describe, of course. You can also use information_schema.columns. Or, you can just select:

select p.*
from tblPerson p
limit 0;

answered Nov 05 '19 at 13:53

Gordon Linoff

1,242,037
58
646
786

How Can I see an empty table structure in mysql?

3 Answers3