0

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

sql coding

22nd Jan 2020, 3:33 PM
Krish008
Krish008 - avatar
2 odpowiedzi
+ 2
//Show columns show specific colums but select * from can select specific columns data or columns
22nd Jan 2020, 3:36 PM
Sudarshan Rai
Sudarshan Rai - avatar
+ 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.
22nd Jan 2020, 3:58 PM
Avinesh
Avinesh - avatar