Is SHOW COLUMNS command different from the SELECT * FROM table name, Command?

Question

sql coding

Answer 1

//Show columns show specific colums but select * from can select specific columns data or columns

Answer 2

SHOW COLUMNS FROM table_name;

The above command is similar to -

DESC table_name;

Both will give you column details like field, type, key etc.

SELECT * FROM table_name;

The above command will display the whole table with all fields and their respective content.