CODEWITHSUNDEEP
mysql
Jack Daniel's
Jack Daniel's

Reputation: 2613

Difference between show column and describe in mysql?

Is there any difference between in MYSQL:-

SHOW COLUMNS from XYZ;

AND

DESC XYZ;

Both seems to give same result

Upvotes: 9

Views: 7891

Answers (2)

Racil Hilan
Racil Hilan

Reputation: 25341

The short answer is, there is no difference between them in the way you used them.

For other types of usages, they have a bit different syntax and SHOW COLUMNS can be a bit easier to use when you want to specify something like a LIKE 'pattern' or a WHERE expr.

Upvotes: 5

peterm
peterm

Reputation: 92785

The source of information in situations like this is the documentation

EXPLAIN Syntax
DESCRIBE is a shortcut for SHOW COLUMNS.
...
The DESCRIBE statement is provided for compatibility with Oracle.

Both provide means for column name pattern matching

SHOW COLUMNS FROM users LIKE '%name';
DESC users '%name';

Here is SQLFiddle demo

Upvotes: 11

Related Questions