Mysql Describe

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

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.

Desc Stu;

Result

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

Advertisements

Ads
Share on Google+Share on Google+

Mysql Describe

Posted on: January 17, 2009 If you enjoyed this post then why not add us on Google+? Add us to your Circles

Advertisements

Ads
 

Discuss: Mysql Describe  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:0

Ads

 

Ads