Organizational Research By

Surprising Reserch Topic

Write a command to view MySQL database table structure



asked Sep 13, 2013 in MYSQL by rajesh
edited Sep 12, 2013
0 votes
26 views



Related Hot Questions

1 Answer

0 votes

To view the database table structure describe command is used that provides the list of all the data fields used in the database table. Example: a table named sales will have the four fields like: name, description, num, and date.

mysql> describe test;
| Field | Type | Null | Key | Default | Extra|
| num | int(11)| |PRI | NULL | auto_increment |
| date | date| | MUL | 0000-00-00 | 
| name | varchar(50) | MUL |
| description | varchar(75) | YES | | NULL
 
answered Sep 13, 2013 by rajesh
edited Sep 12, 2013

...