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 | | | |
+-------+-------------+------+-----+---------+-------+
|

|