Difference between DESCRIBE and EXPLAIN MYSQL statements

Difference between DESCRIBE and EXPLAIN MYSQL statements

Describe : Describe used to obtain information about table structure.

Explain : Command used to understanding and optimizing MySQL queries and will be processed to detect potential performance issues, MySQL displays information from the optimizer about the statement execution plan. Explain command will be used to insert update and other MySQL quires.

Explian Extended : provides additional information and estimates the number of table rows that are filtered.

To explain the DESCRIBE, EXPLAIN, and EXTENDED EXPLAIN we have create a demo database named "demodata". and also create two table department and students.