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  |  




					   |         |       |
+-------+-------------+------+-----+---------+-------+

Related Tags for Mysql Describe:
sql, mysql, c, table, null, sed, type, field, attribute, tab, ie, to, ld, e, des, use, ul, pe, m, tr, es, describe, s, at, my, is, ll, tt, scr, s, s, ri, th, ab, abl, etc, etc, o

«Previous Index Next»