Mysql Describe

Mysql Describe is used to describe the table Field,Type,Null etc attribute .

Understand with Example

The Tutorial elaborate an example from 'Mysql Describe'.To understand this example we create a table 'Stu' with required fieldname and datatype respectively.

Create table

Create Table Stu(Id int,Name Varchar(15));

Query

The Query below  Desc keyword is used to describe the fieldname,Type,Null etc of the table.

Result

+-------+-------------+------+-----+---------+-------+
| Field | Type        | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| Id    | int(11)     | YES  |     |         |       |
| Name  | varchar(15) | YES  |     |         |       |
+-------+-------------+------+-----+---------+-------+