/*************************************************** 
 MYSQL 
 Desc[ribe] table
 List columns, datatype and other info 
***************************************************/
DESC student;


SELECT column_name, column_type, is_nullable, column_key,  column_default, extra
FROM   information_schema.columns
WHERE  table_name='student';


SELECT *                            # List all column info 
FROM   information_schema.COLUMNS   
WHERE  table_name='student';