Mysql Question posted in
The official MySQL documentation can be found here.

Mysql – What is the difference between desc and desc table command?

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

Tags:

2

Answers


  1. 0

    desc is used for arranging the data output in descending order, if you can share a particular query, we can able to answer it

    Login or Signup to reply.
  2. 0

    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;

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search