Describe Table , Will Show Table Details and Structure ,Mysql Field Names, Mysql Fields Type,Mysql Null Fields ,Mysql Field Keys,Mysql Fields Default values

If we wish to see the columns we prepared we can type simple query

 > describe t1 ; 

Will show

Field ,   Type      ,    Null  ,     Key   ,   Default  ,   Extra 
 c1       int(11)
I guess you know field id is column and type is the

Column type, will discuss about others later.

Simple and fast PlanetGhost Mysql Tutorial with Examples.

If You Think This Post has helped you buy us a Coffee :)

Make Donation

  • Other: $

Donate now