Are these two statements equivalent? Why or why not?

Question

SELECT *
FROM table

~~~

SHOW COLUMNS
FROM table

~~~

Answer 1

SELECT will show the data. SHOW will show only column names.

Answer 2

'SHOW COLUMNS ..' is used for getting table schema/structure/definition. It gives you details about all columns and their datatypes, size, default values constraints(if any) etc. Whereas 'SELECT' statement returns data from the table.