desc tablename;
and
desc table tablename;
are giving different outputs.what is the difference?
i wanted to see the structure of the table,but accidentally ended up using desc table command and it led me to a completely different output
New contributor
hansika is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
desc tablename; describes the table – its columns and indices.
desc table tablename; describes a query table tablename;, i.e. it is explain select * from tablename;
4