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 | | | | +-------+-------------+------+-----+---------+-------+ |
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Ask Questions? Discuss: Mysql Describe
Post your Comment