Answer / rahul

DESC <tableName>

This will give you all property of table. Where Key column show you key description.

Answer / sudhanshu_kmr

use this .....

show create table <tablename>;


it will describe all the properties of the table.

here <tablename> is name of table for which u want to know about.

for example-

SHOW CREATE TABLE STUDENT;

Can foreign key have duplicate values?

0 Answers  

---

How to do login in mysql with unix shell.

0 Answers  

---

What is relational database in mysql?

0 Answers  

---

if we want to load data from a text file into a mysql table, but the columns in table are 1st: code(int) and 2nd: city(varchar), but in text file the format is 1st cityname and then code separeted by delimeters. how to load?

2 Answers  

---

Explain the difference between mysql and mysqli interfaces in PHP?

10 Answers   TCS,

---

---

What are the differences between char and nchar?

0 Answers  

---

How do you restart mysql?

0 Answers  

---

What is save point in mysql?

0 Answers  

---

What are the purposes of using enum and set data types?

0 Answers  

---

how to display nth highest salary from a table in a mysql query? : Mysql dba

0 Answers  

---

What is delimiter $$?

0 Answers  

---

Is number a datatype in mysql?

0 Answers  

---